Write timestamp in three cells using Excel VBA
09:47 12 Sep 2024

I need to enter a timestamp in three cells P1, Q3, V3.

I tried below Excel VBA code.

Sub Start_Click()
With ActiveSheet.Range("p1")
    .NumberFormat = "dd/mm/yyyy HH:mm:ss AM/PM"
    .Value = Now()
    .ColumnWidth = 16#
End With
End Sub
excel vba