View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Simple Excel Macro

Not Lotus. Maybe this simple?

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


--
Don Guillett
SalesAid Software

"TimWillDoIt" wrote in message
...
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?