Time stamp cell range

[jamada]

Hi, sorry I'm having difficulties with this, solutions appreciated very much.

I'm trying to time stamp Column "L" and effected rows with current date time (24hour clock)

LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = LastRow To 2 Step -1
If Cells(i, 3).Value > 0 Then
Range(Cells(i, 13)) = NumberFormat "MMMDD hh:mm".Value = Now()

End If
Next i

Tks Graham

 

[BenGee]

Would it work if you changed the number format to;

Range(Cells(i, 13)) = Format(Now(), "MMMDD hh:mm")

 

[jamada]

Hi BenGee, Thanks for the suggestion. Turns our my issue was using "Range", have corrected as follows.
Thank You!

LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = LastRow To 2 Step -1
If Cells(i, 3).Value > 0 Then
Application.EnableEvents = False
Cells(i, 13).Value = Now
Application.EnableEvents = True
End If
Next i

Application.CutCopyMode = False

 

[BenGee]

Ah ok, awesome! Thanks for sharing