Application.sendkeys

  • Thread starter Thread starter Adrie Rahanra
  • Start date Start date
A

Adrie Rahanra

Hello group,

With this macro I want to replace the manual action (press
F2 and enter) to enter the cell.
I've tried this one in a loop but that didn't work.
The result of this macro is that it only does this action
on cell AB2. My objective is to do this for all cells
within the range.


Sub test()
Range("AB2:AB100").Select
Application.SendKeys "{F2}~"
End Sub

Does anybody have a solution?

Regards,
Adrie
 
AFAIK, you can only edit on cell at a time. I.e., when go enter Edit
mode, you can't be editing in more than one cell.

Maybe, there's a solution other than SendKeys. What exactly are you
trying to do?

HTH
Paul
 
Back
Top