Hello,
I need help on a very simple matter (I think...):
When I try to use
Sheets("Dir").Range("B2:B10").Select
in VBA code, there is an error "Select method of range class failed",
and I have to use
sheets("Dir").activate
range(B2:B10").select
What am I doing wrong?
I really don´t want to activate the "Dir" worksheet, just select a range on it and work on that range - sort it, for instance.
Thank you for any help.
Best Regards,
MrDoc
I need help on a very simple matter (I think...):
When I try to use
Sheets("Dir").Range("B2:B10").Select
in VBA code, there is an error "Select method of range class failed",
and I have to use
sheets("Dir").activate
range(B2:B10").select
What am I doing wrong?
I really don´t want to activate the "Dir" worksheet, just select a range on it and work on that range - sort it, for instance.
Thank you for any help.
Best Regards,
MrDoc