Hi Andrew.
Yes, it's arrays I'm working with at the minute, so the Watch window is very useful. And using either global variables or private module-level variables has taken care of the problem.
It beats repeatedly deleting Rng1, Rng2, and Rng 3 (or Str1, Str2, and Str3) from the Watch list for Sub 1, and adding them again to the list for Sub 2, etc. A laptop screen doesn't leave a huge amount of space for the Watch window.
Thanks for your advice
|