I think Range("MyNamed Range"), not Range(MyNamed Range), so in my thought

Range("MyNamed Range").Copy
Workbooks(HomeBook).Sheets("Report").Range("B" & LastRow)
or
ActiveWorkbook.Range("MyNamed Range").Copy
Workbooks(HomeBook).Sheets("Report").Range("B" & LastRow)

would work.

keizi

wrote in message
oups.com...
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.