View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Malik[_2_] Malik[_2_] is offline
external usenet poster
 
Posts: 25
Default 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?