Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making code more efficient
Hello!
I have code, which manages lists (so the code will make heavy use of for-loops, comparisons, sorting, filtering and that kind of stuff = quite basic, but time-consuming). Running my code will in some cases take quite a lot of time. In the beginning of every procedure, I put Application.ScreenUpdating = False ( in the end of procedure again True). I put also Application.Calculation = xlCalculationManual in the beginning (and in the end again to Automatic). Is there any other things, I should take into account, if I want my code run more efficiently? BR, Tommi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making code less column-specific | Excel Worksheet Functions | |||
making code more efficient | Excel Discussion (Misc queries) | |||
Making A Code | Excel Worksheet Functions | |||
Book on how to write VBA code in a fast/efficient manner? | Excel Programming | |||
More efficient code | Excel Programming |