I have another question....If I want to insert another static date and time
stamp (to illustrate the closer of an issue) a few columns over, how do I add
this code to the existing code I already have?

Thanks
Laura

"Laura" wrote:

Yes it worked!!!

Thanks pikapika and Dave.

"Dave O" wrote:

Laura-
pikapika13 is correct: this line
Target.Offset(0, 1).Value = Now()
does the required job, but the line that follows it
Target.Offset(0, 1) = Time
changes it to time only. You can remove that second line or comment it
out, and it should work for you. Please let us know!