|
|
#4
01-16-2025, 01:15 AM
|
|||
|
|||
Yes, remember that Range("A1").End(xlDown) is really ActiveSheet.Range("A1").End(xlDown) = Worksheets(1).Range("A1").End(xlDown)
= cell on Worksheets(1) => Worksheets(2).Range("A1", <cell on Worksheets(1)>) throws an error because you can't use a cell on Worksheets(1) to specify a range on Worksheets(2) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Run Time error 1004
|
Marcia | Excel Programming | 2 | 06-13-2024 07:28 AM |
|
VBA error 1004 Application-defined or object-defined error
|
petedacook | Excel Programming | 1 | 10-27-2022 01:22 PM |
| Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error | PLSBRYDOBOY | Excel Programming | 0 | 08-30-2019 12:17 PM |
| Run Time Error '1004' | galkej | Excel | 0 | 02-03-2014 06:39 AM |
|
Run time error 1004
|
yonasan | Excel Programming | 3 | 06-12-2012 11:08 PM |
Windows 11 
Office 2013
Threaded Mode