J
John V
This simple issue nags at me. In a larger macro, I start off activating a
worksheet and the current region, as follows:
ThisWorkbook.Activate
Worksheets("Transactions").Range("A1").Activate
[This inelegant code is about my fourth iteration at getting this right.]
I will run the macro from the VBA window, and if the Transactions worksheet
is not the active sheet when I start the macro, I will get the error message:
Activate method of Range class failed.
Seems to me that my code should work regardless of which workbook or
worksheet is active, but obviously I'm not understanding something. What is
it?
Thanks, John
worksheet and the current region, as follows:
ThisWorkbook.Activate
Worksheets("Transactions").Range("A1").Activate
[This inelegant code is about my fourth iteration at getting this right.]
I will run the macro from the VBA window, and if the Transactions worksheet
is not the active sheet when I start the macro, I will get the error message:
Activate method of Range class failed.
Seems to me that my code should work regardless of which workbook or
worksheet is active, but obviously I'm not understanding something. What is
it?
Thanks, John