Recording the 1st Change in the value of a cell
I have a spread sheet that looks like so before the start
of the trading day:
ColA ColB ColC
ABC 4/7/2005
ColB tracks the trade time of stock ABC - it comes from a live data feed.
When ABC does it's first trade, the spreadsheet looks
like so - and continues to change as subsequent trades occur.
ColA ColB ColC
ABC 9:32:28AM
Is there a macro that will record the time of the first trade and place it in ColC ??
Thank you in advance.
|