View Single Post
  #3   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi George

Sure. It is very simple:

Range("A5").Value = Date

You can also use Now (for date and time) and Time (for time without date)

HTH. Best wishes Harald


"George Gee" skrev i melding
...
Happy new year to all!

I recorded this macro some time ago, the cell A5 is selected at the end of
the macro,
ready for the user to insert today's date.
How do I edit the macro to insert today's date into cell A5, when it is

run.

I do not want to use =TODAY() as this would change the date, daily,
(does that make sense)?

Many thanks

--
George Gee
--