" wrote:

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.




Is mynamedrange a variable within the macro or the string name of the range
in the spreadsheet. If it is latter try to type
range("mynameddrange")

if you use this a varaibe use like this
dim mynamedrange as string
set mynamedrange=range("J35:Q35")
then
mynamedrange.copy ..............

try soemthing on thee lines.