Quote:
Originally Posted by whatsup
Basically it's important that you can't use ActiveSheet in a macro if you start the macro from another sheet - obvious isn't it?
|
Unless, of course, your code activates the sheet concerned (e.g. ThisWorkBook.Sheets("MySheet").Activate). But even that requires the sheet to be named for activation. Not a recommended way to program - it's both inefficient and error-prone.