Cells which contain NOW will recalculate automatically whenever the workbook
is recalculated.

Dave
--
Brevity is the soul of wit.


"Tino" wrote:

I need to auto insert date/time in column A when an area is picked from
pulldown in column B. I have this: =IF(COUNTA(B45)<0,NOW(),"") it works but
it updates all previous in column A.