Thread
:
Simple Excel Macro
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett