Out of memory error

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

Good Day,

I'm trying to use Excel to generate a report on the 30 Dow Jones Industrials
that contains

symbol date closingprice MovingAvg. The worksheet contains a workarea
that I read

the historical data into, calculate the MA and then use Paste Special Value
to bring the

data to the report area, after which I delete the input data and repeat the
sequence for

the next stock.


The problem appears to be that no storage is released when deleting the
input data and

after 15-20 stocks are done, the Out of Memory condition occurs.


Does Excel release memory when a range is deleted ? Even if it's reused in a
subsequent

operation? If Excel does not automatically release memory is there an
explicit instruction

I can issue such as a VB GC (garbage collection) ?


The entire worksheet occupies cells A1.T15000 but cells A40.I15000 are
unused. Would it

help to use only cells A1.I15050? In other words, does Excel use memory for
cells that are

blank?



Thanks for your time, J e r
 
Back
Top