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