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!