Did you solve this problem? I'm trying to do the same thing.
-- Otto

"leshik" wrote:

Hi

I'm pulling realtime stock data into Excel 2002 by DDE
populating each next lower row with the latest data. In
other words the column length is constantly increasing.

The application sets up an array to a requested size (of N
rows) and populates it with all #N/A. The incoming data
then replaces these #N/As sequentially, top down.

What I would like to achieve is to set an array (of N rows)
where the newest data is written to the bottom row and the
top row is deleted. The array thus remains the same size
showing only the last N latest updates. (Latest on bottom
row, oldest on top row).

Any VBA help would be much appreciated

leshik