Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook that imports and manipulates data from another worksheet.
I press 1 button which in turn runs about 30 subroutines and functions totalling about 2200 lines of actual VBA Code. Call it morbid curiosity or bragging rights... or just pure inefficiency but I'd guess I probably run through anywhere from 100,000 to 500,000 lines of code just because of all the loops, functions & subroutines. Obviously that number also changes based on the amount of data that I'm trying to import. I'd like to have a way to count lines of code executed from when I push the button until it's all done without slowing the code down. I'm visualizing something similar to taking the "now" time at the beginning and end, caclulating the difference.... but with lines of code. This would also help me to improve the efficiency because I could run the same source data file for each change to see if it really helped. Thanks, MikeZz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I call VBA subs from different spreadsheet from code behind form? | Excel Discussion (Misc queries) | |||
Count lines code in workbook | Excel Programming | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
part of a code not being executed | Excel Programming |