Hi all,
I know this problem has occurred here before, but none of the solutions posted has helped me.
I have a few subs, all independent from one another (for now), in the code of one of my worksheets. Now in the last sub I am getting an error "1004 Application- or Object-defined error" when the program reaches the following line:
Now, my initial code involved some variables in the cell definitions, but after a bit of wriggling around it won't even do the above. The following will work:
But even this is too much:
I'm a bit helpless, because the exact same code works fine in the other macros. I've tried changing the sheet, I've unlocked all my sheets and cells, but this won't go away.
Any help is greatly appreciated.
Regards,
Nyota
I know this problem has occurred here before, but none of the solutions posted has helped me.
I have a few subs, all independent from one another (for now), in the code of one of my worksheets. Now in the last sub I am getting an error "1004 Application- or Object-defined error" when the program reaches the following line:
Code:
ActiveSheet.Range(Cells(1, 1), Cells(2, 2)).Select
Now, my initial code involved some variables in the cell definitions, but after a bit of wriggling around it won't even do the above. The following will work:
Code:
ActiveSheet.Range("A1").Select
But even this is too much:
Code:
ActiveSheet.Range("A1:A2").Select
I'm a bit helpless, because the exact same code works fine in the other macros. I've tried changing the sheet, I've unlocked all my sheets and cells, but this won't go away.
Any help is greatly appreciated.
Regards,
Nyota
Last edited: