this statement works correctly:
wbFrom.Sheets(1).Cells(2, 6).Copy Destination:=wbTo.Sheets(strWklySheet).Cells(5, 4)
this one gives Run-time error 1004 - Application-defined or object-defined error
wbFrom.Sheets(1).Range(Cells(2, 7), Cells(2, 15)).Copy Destination:=wbTo.Sheets(strWklySheet).Range(Cells(5, 6), Cells(5, 14))
The fact that the first one works tells me the problem is NOT in the workbook and sheet names, but is apparently tied to defining a multi-cell range in this format. Or, more likely, there's a simple formatting error I'm making that I just can't see.
Bookmarks