![]() |
#4
|
|||
|
|||
![]()
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) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Marcia | Excel Programming | 2 | 06-13-2024 07:28 AM |
![]() |
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 |
![]() |
yonasan | Excel Programming | 3 | 06-12-2012 11:08 PM |