View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John[_88_] John[_88_] is offline
external usenet poster
 
Posts: 205
Default Cell update formula

Good point.

You might want to change that to:

Cells(iRow, 1).Value = CStr(Now())

Best regards

John


"JLGWhiz" wrote in message
...
Be aware that the Now() will recalculate each time you open the file
whether
there is a change or not.

"CDDAH NHS" wrote:

Excellent, thanks John!