I am building a macro and would like the macro to update a cell to say "Data
Locked - <date when macro was run". I have tried to used the CTRL+; command
to insert the date, but when recording the macro, the actual date text is
recorded and I am stuck with a date that is hardcoded to the time I built the
macro. Any thoughts?

Thanks!

Hi

not sure if i'm missing something here, but if in your macro it has
something along the lines of


'your current code
Range("A1").value = Format(NOW(),"dd/mm/yyyy")
'your current code

every time you run the macro, the date of running the macro will be inserted
into A1

Cheers
JulieD




"Spyder" wrote in message
...
I am building a macro and would like the macro to update a cell to say
"Data
Locked - <date when macro was run". I have tried to used the CTRL+;
command
to insert the date, but when recording the macro, the actual date text is
recorded and I am stuck with a date that is hardcoded to the time I built
the
macro. Any thoughts?

Thanks!

Activesheet,Range("H10").Value = "Data Locked - " &
Format(Date,"yyyy-mm-dd")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Spyder" wrote in message
...
I am building a macro and would like the macro to update a cell to say
"Data
Locked - <date when macro was run". I have tried to used the CTRL+;
command
to insert the date, but when recording the macro, the actual date text is
recorded and I am stuck with a date that is hardcoded to the time I built
the
macro. Any thoughts?

Thanks!