MACRO Code for Date and Time stamp

[poikl]

Hi, Can you please help write the code for MACRO where it would stamp the Date AND TIME?
Currently I have "Cells(c.Row, "A") = Format(Date, "m/d/yy")" (which you had written for me quite a while back)
But I now need that it should also include the TIME

 

[myall_blues]

Here's an example. You can modify the time format to suit how you want it to appear.

Cells(c.Row, "A").Value = Format(Date, "m/d/yy") & " " & Format(Time, "hh:mm:ss")

Alternatively you can use

Cells(c.Row, "A").Value = Format(Now, "m/d/yy hh:mm:ss")

 

[poikl]

Thank you so much, Myall, exactly what I needed.