Update date and time in Excel Document
Posted by Vu Dinh on September 28, 2001 12:25 PM
How to set up function for update the dates, times in Excel document? Every time when I make any changes in this document, I want to know automatically the date and time when I make that change.
thanks,
Vu Dinh
Posted by Greg Collett on September 28, 2001 1:23 PM
Vu
Try to use the =Now() function. It records the date and time that the workbook is opened or calculated.
It can be incorporated into a macro but you have to be careful that it does not become unstable if you use a cell change macro.
Hope this helps
Cheers
Greg
