Look at Chip Pearson's page on the use of the ontime method

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"Paul" wrote in message
...
can someone tell me how to periodically log the values in
a single cell.

I have a real time data feed into a single cell that i
would like to track historically - minute by minute.

The function I seek would record the values of the cell
each minute.

Is there a way???