Hi Paul,
For lots of tips about Excel performance, visit Charles Williams' site:
www.decisionmodels.com
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"PaulW" wrote in message ...
|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...