I've got a user-type array set up and populated in a code module other than where I'm stepping through code to debug.
The arrays are Global (on top of the code).
Where I'm stepping, I've tried setting up a watch (they don't show up in the Local window pull-down) as;
myInfo
myInfo()
Module30.myInfo
Module30.myInfo()
...
Is there a way to view an in-scope variable that doesn't reside where the code is currently running/stopped/single-stepped in debugging modes?
At present, the only way I've had to review data is debug.print or moving the array around to where the code is running (annoying!)...
==========
Also got another (unrelated) issue --- crashes if I don't close and reopen the workbook after running some code and userforms ... anybody know of a utility to export then import all the modules and userforms to a new workbook? I've got some 40 odd to do and don't want to try it manually (I've read that extensive modules/editing in VBA can cause this issue)
TIA
Grug
Bookmarks