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?
|