Based on what you appear to expect to happen, use this

Sub Macro1()
ActiveCell.FormulaR1C1 =
Right(ActiveCell.FormulaR1C1,Len(ActiveCell.Formul aR1C1) - 1)
End Sub

Watch the wrap, there only 1 statement line.


IConsultIT wrote:

Apparently as soon as I hit "F2" it pauses the recording and does not record
the "F2""Home""Delete" sequence.