View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mike.r.harris@blueyonder.co.uk is offline
external usenet poster
 
Posts: 11
Default 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.