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

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

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?

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?