View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adrie Rahanra Adrie Rahanra is offline
external usenet poster
 
Posts: 3
Default 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