I have a Macro which has around 1000 lines in it. I wanna see what the Macro is doing, when being RUN...
Just a question: 1,000 lines of VBA code?
Hmmmm... I wonder if it might be better to reorganize and code in units (self-contained), which is part of the structured programming approach (see John Walkenbach, Excel 2002 Power Programming with VBA, page 213). This approach means that the VBA code is easier to build, easier to maintain, easier to trouble-shoot, and easier for someone else to come in and use, maintain, update, etc.
old, slow, and confused
but at least I'm inconsistent!