Automatic date stamping
Thats great, exactly what I was after.If I want to put a time stamp on it
also do I just enter time after the word "date".
Thanks again for your help
--
pk
"Gary''s Student" wrote:
It may be a formatting issue.
1. Remove the previous macro
2. Instert this one in its place:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Range("A1").Value = Date
Range("A1").NumberFormat = "dd mmmm yyyy"
Application.EnableEvents = True
End Sub
--
Gary''s Student - gsnu200752
"PK" wrote:
It appears that every time I carryout an edit it changes the date date to a
different one none of which have been correct
--
pk
"Gary''s Student" wrote:
What is the date that you see in the cell and what is the date on your
computer??
--
Gary''s Student - gsnu200752
"PK" wrote:
Thank you for that however I find that the date being entered is incorrect
and does not match the date on my computer.
Thank you again
--
pk
"PK" wrote:
I Woukd like to a date stamp to to entered in to a cell within aspreadsheet
and refreshed each time the spreadsheet is updated.
Is this possible
--
pk
|