This is my code:
Sheet4.Range("A3", Cells(l_LastRow, l_LastColumn)).Select
I get the error message: "Method 'Range' of object '_Worksheet' failed"
It's a runtime error 1004.
I get this error whenever the active sheet is any sheet besides Sheet4, and using Worksheets("SheetName") in place of Sheet4 doesn't work either, instead getting an "Application-defined or object-defined error."
What's going on?
Bookmarks