Date macro

[james]

how do i use a maco to date a doc with today's date, which
will not be updated in the future, unless the macoo is run
agaain?

 

[Don Guillett]

sub setdate
range("a1")=date
end sub

 

[Jerome_t]

-----Original Message-----
how do i use a maco to date a doc with today's date, which
will not be updated in the future, unless the macoo is run
agaain?
.

Macro to Run:
sub toto()
Range("A1") = Date
Range("A2") = Time
end sub

 

[Bob Phillips]

Sub InsertDate
Range("A1") = Format(Date,"dd mmm yyyy")
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)