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

Please Login or Register  to view this content.

, 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 :=(

Please Login or Register  to view this content.

Any suggestions would be great - thanks

You can try to use this code:

Please Login or Register  to view this content.

Regards,
Antonio