One way:
Designate some cell somewhere as the place where the first time value is
stored. Make sure this cell is blank when the day starts.
Then use a Worksheet_Change event macro to take the value in the time
cell (the cell that keeps changing) and put it in this designated "First
time" cell, if that cell is empty. That cell won't be empty after the first
time and so will remain static. Post back if you need more. HTH Otto
"carl" wrote in message
...
I have a spreadsheet that monitors the opening time of some stocks. In the
morning before trading starts it looks like this:

Stock TIME
QQQQ-O 2/15/06
AAPL-O 2/15/06
GOOG-O 2/15/06
CSCO-O 2/15/06
SPY-A 2/15/06

When trading starts, the TIME value records the time of the last trade,
thus
the first time will represent the time of the first trade - I am trying to
capture this time value. The problem is that if another trade occurs, the
TIME value updates to the time of that last trade. The TIME value is fed
by a
DDE link from a data source.

Is there a way to capture the "first" change in the TIME value ?

Thank you in advance.