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