View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spyder Spyder is offline
external usenet poster
 
Posts: 7
Default Macro / VB / Instert Date Question

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!