Date

verluc · Apr 24th, 2002, 03:30 AM

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 · Apr 24th, 2002, 03:35 AM

Try this:

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

Audiojoe

[ This Message was edited by: Audiojoe on 2002-04-24 02:35 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 03:30 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,288	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

Apr 24th, 2002, 03:35 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Try this: Range("d4").Value = Format(Date, "dd mmmm yyyy") Audiojoe [ This Message was edited by: Audiojoe on 2002-04-24 02:35 ]