Originally Posted by
gototcm
. . . This is the simple one line of code that is throwing the 1004 error. . . .
Sheets("sheet3").Range(Range("A1"), Range("D10")).Select
The best approach for this has already been given. I'll address what didn't work with this.
Unqualified Range(...) calls implicitly refer to ActiveSheet, so the statement above is effectively the same as
Sheets("sheet3").Range(ActiveSheet.Range("A1"), ActiveSheet.Range("D10")).Select
If Sheets("sheet3") isn't ActiveSheet, then its .Range property won't accept arguments referring to ranges in other worksheets. Probably best to get used to
Bookmarks