Application.sendkeys
 

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

Application.sendkeys
 

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
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

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