Can't copy named range
Why will this work.....
Sheets("Configuration").Range("J35:Q35").Copy
Workbooks(HomeBook).Sheets("Report").Range("B" & LastRow)
but not this.....
Sheets("Configuration").Range(MyNamed Range).Copy
Workbooks(HomeBook).Sheets("Report").Range("B" & LastRow)
can't seem to reference a named range in the copy line? Any help
appreciated.
|