XL's recorder only records results of your actions, as you've found.

One way:

Public Sub InsertLetters()
ActiveCell.Value = "AB" & ActiveCell.Text
End Sub

In article ,
TimWillDoIt wrote:

OK, OK...so (technically) I'm not a "new" user of Excel. I've created simple
macros in older versions of Excel, before macro and Visual Basic meant the
same thing.

I want to create a simple macro, but VB is foreign to me. All I want the
macro to do is press F2 (to edit the text in a cell), hit Home (to go to the
beginning of the cell contents) and insert a couple letters.

However, when I record it, the VB script replaces the text in my cell with
the text that was in the cell I used to record it.

Anyone know how to get Excel to do the simple macros it used to do?