Search for "System Date/Time into a Cell or within Code" on David
McRitchie's WebPage for insight into how to handle this issue.

http://www.mvps.org/dmcritchie/excel/datetime.htm

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Sat, 27 Sep 2003 15:04:56 GMT, "M. lane" wrote:

My question; is there a way to enter a date in a cell that will not update
each time I re-open the workbook, but rather go to the next row in that
column and enter a new date.