memory issues with Excel

[raj]

Hello -

I have the following queries re. memory allocation in Excel

1. Can one increase the total allocation of memory
2. How can clean variables from memory

The reason - I have a for-next loop running a number of
processes. I initialize all variables at the end of the
loop, but for some reason, memory usage keeps increasing
and excel crashes out after a while.

Any guidance appreciated.

Regards, Raj

 

[Steve Smallman]

Raj,

Are you using redim'd arrays?

It sounds to me more like a recursive loop is running. i.e. your code is
calling itself from within itself.

try using a subset of your data, and having excel prompt you with a msgbox
containing your variables to see if they are within the correct ranges and
to try and determine whether you are calling the routine from within itself.
If all else fails post the code.

Steve