Insert Date and time in Cell

[Eric]

Hello,

I am looking for a line of code that I could add to the end of my macro that
would insert the date and time the macro was first run into a cell named
"vLeadWriteDate". Any help would be great.

 

[JLGWhiz]

vLeadWriteDate = now

Be sure the column is wide enough or you will see ########.

 

[JLGWhiz]

If you only want the first occurance, then

If vLeadWriteDate > "" The
'Do nothing
Else
vLeadWriteDate = now
End If

 

[JLGWhiz]

I'll get this right pretty soon. This should do it:

If Range("vLeadWriteDate") > "" The
'Do nothing
Else
Range("vLeadWriteDate") = now
End If