List variables in worksheet
Using Excel XP.
How would I get a list of all the variables, their type (public, private,
including arrays, no need for local variables), the module and the subs or
functions they are used in in a worksheet?
Had a look at different freeware utilities, but found nil yet that can do
this.
The purpose is to make it easier to split up one large module into smaller
ones.
Thanks for any advice.
RBS
|