Tom,
Many thanks for that - it worked.

However I'm concerned that SendKeys only works on the
Active window. Do you know a way to ensure the key
strokes go to the correct window ?

Regards
Michael


-----Original Message-----
Sub AAAtest()
Cells(1, 1).Select
SendKeys "{F2}"
End Sub

--
Regards,
Tom Ogilvy



Michael Gree wrote in
message
...
Hi,
How do I open a cell for edit from code ie as if the
user
had pressed F2...
Regards
Michael Green


.