Insert actual timestamp shortcut keystrokes in Excel VBA code instead of the value initially produced by the shortcut

Hello,

How do you modify Excel VBA macro code (containing a keyboard timestamp shortcut) so that, each time the macro is invoked, it reproduces the actual shortcut keystrokes (and therefore the current time) rather than the "absolute" time value the shortcut produced when the macro was originally recorded?

After clicking to Use Relative References (ie Developer > Use Relative References), the Excel macro recorder was used and created the following code:

Sub Macro12()
'
' Macro12 Macro
'

'
    Application.Goto Reference:="DateEnd"
    ActiveCell.Offset(0, 2).Range("A1").Select
    Selection.End(xlUp).Select
    ActiveCell.Offset(1, 0).Range("A1").Select
    ActiveCell.FormulaR1C1 = "11:59:00 AM"
    ActiveCell.Offset(0, 3).Range("A1").Select
End Sub

Select allOpen in new window

The relative actions (keystrokes) appear to have been recorded properly except for the following row:
       

ActiveCell.FormulaR1C1 = "11:59:00 AM"

Select allOpen in new window

At this particular part of the recording, the shortcut [Ctrl+Shift+;] was used to enter the current time. As is shown above, the time when the macro was being recorded was apparently 11:59 AM. However now, each time the macro is run, it does not enter the current time as it should but enters 11:59 AM.

So how must that row of code be modified so that each time the macro is run in the future, it will reproduce the keystrokes shortcut and post the current time then instead of always entering 11:59 AM?

By the way, I tried to come up with a different method for entering the current time. However, I could not find a timestamp icon in the Ribbon nor could I come up with a formula for its entry. That particular column is formatted to display a time and entering the function =NOW() accurately produces it — but obviously, that value will update every time the spreadsheet calculates unless some kind of Copy/PasteValue step is included.

Thanks