Copy/Paste Named Fields

[Ed S.]

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...

 

[Al Chara]

Try the following code:

Sheets("NewSheet").Range("B:B").Value = Sheets("DetailSheet").Range("Name1").Value