Updating excel range with dynamic price data

Hi

I have a function that gets me the last bid price of a stock and displays it in a single worksheet cell. It's inside some timer code so it gets the price each second.

But what if I want to show the last 10 bid prices in

the range("a1:a10")

, and when the 11th came in all the values would move up a row, so I see just the last 10.

I was thinking something like the following - but obviously I can't get it working :=(

m_BidPrice = myArray(i) 'put the bid into the array
i = i+1 
If i > 10 then somehow move all the values up 1 in myArray()
select the sheet
range("a1:a10")=myArray

Any suggestions would be great - thanks