Andy, Harald.

Thank you very much, just what I wanted!

George Gee



*Harald Staff* has posted this message:

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
--