View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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.