Versions 97, 2000, & 2003 vbGeneralDate

[khalid79m]

I have the following code:


With Activcell
.Valule=FormatDateTime(Now,vbGeneralDate)
.value=.value
End with


This code works fine in 2000 & 2003 but in 1997 it comes up with the following

Complie Error
Variable Not Found.

I need this code to work in 97,2000 & 2003

Can anyone assist

[markmrw]

Try using this

.value=Now()
instead of

.value=FormatDateTime

Mark

[khalid79m]

thanks mate works a treat

[markmrw]

no worries :)