Hello, I am new to Macros. This should be simple. All I want to do is put an apostrophe in front of a five digit number. So i recorded a Macro, it is basically {F2}{HOME}{'}{ENTER}. I recorded it on the first number on the list which was 68410. The next number on the list is 67450; when I run the Macro, it changes the 67450 to 68410; not what I wanted - I only want an apostrophe in front of the 67450.
I looked to edit the Macro, this is what it has, but I am unsure what to do:
--------------------------------------------
Sub Macro3()
'
' Macro3 Macro
' edit a cell
'
' Keyboard Shortcut: Ctrl+a
'
ActiveCell.FormulaR1C1 = "'68410"
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
--------------------------------------------------
thanks for any help! Mike
Bookmarks