I am trying to find a way to run only part of a macro from another macro while a variable condition is met. Let's call it "switch". I want to call macro1 from within another macro(macro2) while switch=1 and "turn macro1 off" when switch=0. The switch variable is just a dummy in macro1 whose only purpose is to switch macro1 on and off from macro2. I tried using a do while loop but I don't think that it checks the value constantly...any thoughts would be helpful
Also my code is part of a project of macros that interact and is about 1500 lines long and I am trying to slim it out by not having to repeat code. That's why I am trying to call only portions of macros.
Bookmarks