Getting Object 1004 Error for a Dyamic Range

batman1 · #2 01-15-2025, 03:32 PM

This is because when the code is run, Worksheets(1) is active, so Range("A1").End(xlDown) means a cell on Worksheets(1), so
Worksheets(2).Range("A1", <cell on Worksheets(1)>)
causes an error.

Write code that is independent of the active sheet, e.g.

Code:

    Set namesRange = Worksheets(1).Range("A2", Worksheets(1).Range("A2").End(xlDown))
        Set tasksRange = Worksheets(2).Range("A1", Worksheets(2).Range("A1").End(xlDown))

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