Macro? or??

  • Thread starter Thread starter IConsultIT
  • Start date Start date
I

IConsultIT

I realize that this may seem like a silly question...so be it. I'm trying to
create a macro that will perform the following keystrokes; "F2" or edit,
"Home" and "Delete". What is the best way to do this?

Thank you,
 
Bob,

I tried that several times and it did not record the key strokes. It merely
moved what was in the first cell to the sub-sequent cells.
 
Apparently as soon as I hit "F2" it pauses the recording and does not record
the "F2""Home""Delete" sequence.
 
Hi David

That is not the way Excel macros work. Compare

Click cell A1
Click the 1 key on the keyboard
Click the 2 key on the keyboard
Click the Enter key on the keyboard

to

Range("A1").Value = 12

HTH. Best wishes Harald
 
Based on what you appear to expect to happen, use this

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

Watch the wrap, there only 1 statement line.
 
Back
Top