Copy name range to specific workssheet

[7thMonth]

The name range is called ReportCopy and the range formula is a dynamic =OFFSET('C Register'!$H$1,,,COUNTA('C Register'!$H:$H),6)

The Nacro I am trying to us is: ' Keyboard Shortcut: Ctrl+e
'
Sheets("C Register").Select
Range("ReportCopy").
Selection.Copy
Sheets("Report").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Any and all help appreciated.

 

[Norie]

Does this work?

Sheets("C Register").Range("ReportCopy").Copy
Sheets("Report").Range("A1").PasteSpecial Paste:=xlPasteValues