Date

[verluc]

I have a macro in which I insert a date,like:
Range("D4") = "23.04.2002"
How can I get that this date is automaticly
the current date,so that I don't need to insert every day a new date?
Many thanks

 

[Audiojoe]

Try this:

Range("d4").Value = Format(Date, "dd mmmm yyyy")

Audiojoe
This message was edited by Audiojoe on 2002-04-24 02:35