I am constructing a new WrkSheet based on columns from a Detail WrkSheet.
I would like to use a reference name (Name1) field as opposed to qualified coding (A:A). In other words, use a named reference (see Ctl F3 when workbook open), and then copy this reference from detail to new work sheet.
This piece of code is close to what I am trying to do, but fails:
'Selectand Copythe Reference Field.
Sheets("DetailSheet").Select
Columns(Name1).Select
Selection.Copy
' Paste the selction to New Sheet.
Sheets(NewSheet).Select
Columns("B:B").Select
ActiveSheet.Paste
Any Help is greatly appreciated...
I would like to use a reference name (Name1) field as opposed to qualified coding (A:A). In other words, use a named reference (see Ctl F3 when workbook open), and then copy this reference from detail to new work sheet.
This piece of code is close to what I am trying to do, but fails:
'Selectand Copythe Reference Field.
Sheets("DetailSheet").Select
Columns(Name1).Select
Selection.Copy
' Paste the selction to New Sheet.
Sheets(NewSheet).Select
Columns("B:B").Select
ActiveSheet.Paste
Any Help is greatly appreciated...