Insert Date and time in Cell
 

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.

Insert Date and time in Cell
 

vLeadWriteDate = now

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

"Eric" wrote:

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.

Insert Date and time in Cell
 

If you only want the first occurance, then

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

"Eric" wrote:

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.

Insert Date and time in Cell
 

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

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



"JLGWhiz" wrote:

If you only want the first occurance, then

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

"Eric" wrote:

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.