| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I optimize this code?
Joel wrote:
set ClearRange = Range(cells(iRow,iFirstCol),cells(irow,iLastCol) ClearRange.ClearContents ClearRange.ClearComments I think the Clear comments is what slows the code down significantly. That was it! Together with Application.Screenupdating = False, it now clears sheets almost instantly! :-) Gustaf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hou would you optimize this code? | Excel Programming | |||
| Optimize SumProduct | Excel Discussion (Misc queries) | |||
| Optimize SumProduct | Excel Worksheet Functions | |||
| How to optimize and improve that code ? | Excel Programming | |||
| How can I optimize this code? | Excel Programming | |||
Threaded Mode
