Release Memory
 

Hi,

I have a macro, and it uses an array that is pretty big Array(7000,361,26)

So if I call the macro that uses this array over and over, is there any way
to "erase" the array so the memory is used more efficiently and the macro
runs faster? Like a clear memory command?

Thanks

Release Memory
 

Look at Erase in VBA's help.

Jeff wrote:

Hi,

I have a macro, and it uses an array that is pretty big Array(7000,361,26)

So if I call the macro that uses this array over and over, is there any way
to "erase" the array so the memory is used more efficiently and the macro
runs faster? Like a clear memory command?

Thanks

--

Dave Peterson