Hmm.. Doesn't here.

Another way:

Public Sub try()
With Range("A1")
.Value = Time
.NumberFormat = "00:00:00"
End With
'rest of macro
End Sub

In article ,
Nagesh wrote:

Your solution works, but the date is inserted as 1/1/1900..I have instead
used =now() instead of Time

Thanks for getting me going


"JE McGimpsey" wrote:

One way:

Public Sub try()
Range("A1").Value = Time
'rest of the macro
End Sub