Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with 5 pages, 2 are external reports, 2 are "calc"
pages, and one is a "Final" page. Also wrote into the workbook is an 8 page Userform filled with a good hundred textbox's, combobox's, labels, and buttons. As i've developed this workbook it gets slower and slower do to additional formulas, and such. Now it's finished and I need to speed it up. Only 2 processes are really slow out of the entire thing, and running one after the other takes in excess of 10 minutes. Basically, I need to speed these things up. but with the vast amount of code, and formulas, can I easy run a macro or something, and find out which cells/lines of code are taking up processing power/time/etc... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct against worksheet vs named range- any speed difference? | Excel Worksheet Functions | |||
Worksheet speed with array formula | Excel Discussion (Misc queries) | |||
Speed up calculation of a worksheet that contains formula | Excel Worksheet Functions | |||
Worksheet copy speed | Excel Programming | |||
raw speed for excel worksheet functions? - xll -or com addin? | Excel Programming |