Simple Excel Macro

[Guest]

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?

 

[Don Guillett]

Not Lotus. Maybe this simple?

Sub addtexttostartofcell()
ActiveCell = "aa" & ActiveCell
End Sub

 

[JE McGimpsey]

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

 

[Guest]

Yes...this is exactly what I need. I apologize for not being familiar with
VB scripts. I'm only just starting to scratch the surface of Actionscript in
Flash.

 

[Guest]

Yes...this did what I needed it to do. I never wrote macros in Lotus, but it
might have been Word.

 

[Don Guillett]

Glad to help