Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel process slows down
After running a macro a few times that is a little involved in sorting data
the macro starts to take a long time to complete. Why might that be? Can it be fixed? Thank you, Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel process slows down
Hi Steven,
============ After running a macro a few times that is a little involved in sorting data the macro starts to take a long time to complete. Why might that be? Can it be fixed? ============ To maximise your chances of a useful response, try posting your code. --- Regards. Norman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel process slows down
Same issue is outstanding:
The question is ; Can memory start to get used up and held onto and therefore causing a macro to slow down? If that can happen then how can the memory be cleared to gain back performance? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel process slows down
Steven,
Are you initating any object within the code? Then you should destroy the object after the Sort finish. Please paste macro code here ane it will help. i.e. If you are using this: Dim oRange as EXCEL.Range Set oRange = Range("MyRange") ---- -- -- Set oRange = Nothing Malik "Steven" wrote: Same issue is outstanding: The question is ; Can memory start to get used up and held onto and therefore causing a macro to slow down? If that can happen then how can the memory be cleared to gain back performance? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel worksheet slows computer | Excel Worksheet Functions | |||
Excel slows down for no(?) reason... | Excel Discussion (Misc queries) | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
Excel macro slows down on second run | Excel Programming |