current Date and time in cell

D

Dave Peterson

=now()
format as date and time.

This will update whenever excel recalculates.
 
G

Gary''s Student

Put the folowing macro in This Workbook code:


Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Cells(1, 1).Formula = "=NOW()"
Cells(1, 1).Value = Cells(1, 1).Value
End Sub

Everytime you open the workbook, cell A1 in Sheet1 will be time/date marked.
 
Top