Error 1004 on Range Select Method

[Nyota]

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:

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:

ActiveSheet.Range("A1").Select

But even this is too much:

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

 

[Sektor]

This happens because of two things:
1) your code is in worksheet module - and not in standard module;
2) the "ActiveSheet" is not the one the code belongs to.
All you need is to put your code into standard module and change "ActiveSheet" to "Sheets("THE_NAME_OF_WORKSHEET")" and call it from worksheet module.
Good luck.

 

[Nyota]

Hello Sektor,

oh dear, such an easy fix. It works very well indeed. Lesson learnt for the next time!
Thanks a lot!

Nyota