| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Slow Peformance on Formatting
I am using Excel 97 and have been trying to use macro to do formatting on certain cells based on the value (Conditional Formatting doesn't work as I have more then 5 conditions). The program works fine but it takes way too long to do it. For example, a procedure that completes in 10 second would take 50 seconds. Anyone knows why it takes this long? And how to speed it up?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel2007 Conditional Formatting Slow Performance Issue | Excel Worksheet Functions | |||
| VERY SLOW | Excel Discussion (Misc queries) | |||
| Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
| MS Excel is too slow when formatting, setuping page, etc. | Excel Discussion (Misc queries) | |||
| How can I improve the snail-pace peformance of Excel 2003? | Excel Discussion (Misc queries) | |||
![Anson[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
