| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet name variables | Excel Discussion (Misc queries) | |||
| Trying to match up variables to a common list and confirm | Excel Worksheet Functions | |||
| Transfer a list of info dependent upon variables | Excel Discussion (Misc queries) | |||
| Select one variable from a list of variables by clicking one cell | Excel Discussion (Misc queries) | |||
| Worksheet template variables | Excel Worksheet Functions | |||
Hybrid Mode
