JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,691
- Office Version
- 365
- Platform
- Windows
It is my habit to make all variables local. I wish that were the Excel default. But once in awhile, I get into the situation I have now where a workbook has 5-6 similar sheets. Several of them have the same local variable. I would like to make one of them global, have all sheets refer to that one instance, and delete the others.
Is there straightforward way to do that that does not involve editing any formulas or installing an add-in?
Thanks
Is there straightforward way to do that that does not involve editing any formulas or installing an add-in?
Thanks