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.

When ABC does it's first trade, the spreadsheet looks
like so:

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.