|
-
NullPointerException
Excel VB Macros
I was just handed an Excel spreadsheet which contains 68 separate modules which hold about three times that many macros. Printed out, this is about 3/4" of paper!
I need to start digging through this code but it's kind of overwhelming with Excel's Alt+F8 setup. All I have is a list of Module numbers on the left column and no cross-reference as to what modules have what macros, or even what sheet they're called from. The Object Browser is a step in that direction, but it doesn't help much.
Is there a better tool to use for this? The "Project Explorer" and "Property Window" leave a lot to be desired.
------------------
The price of freedom is high.
Open Source is free like a puppy is free.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
Understanding Evolution
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|