With VBA: activate a worksheet from a file by calling it in a macro from another file
Posted by Camille on April 24, 2001 12:42 PM
I created a file where my sheets have names and I used to store data in those sheets, calling them by the following code:
Where the name of the sheet I want to activate is written in cell A1 of Sheet1.
This works when the macro is in the same file as the relevant sheets but it doesn't if the code is in another opened file. The error is "subscript out of range".
How could I do?