doubleclick mrehod

[Guest]

According to Microsoft VB help the below should send a double click - but
this is not working - any idea how I can send a double click on a cell in
Excel.

Thnaks
Dan

Worksheets("Sheet1").Activate
Application.DoubleClick

 

[Guest]

Hi Dan

Taken from the VBE help section
"This example double-clicks the active cell on Sheet1."

all that that does is simulates a user dbl Clicking the Active Sheet, which
will not do anything unless you have written an event handler for the
Sheet1_DblClick event

HTH

 

[NickHK]

Dan,
Yes, Excel 2002 that seems to do nothing.
Depends what you are trying to achieve ??

SendKeys "{F2}"

NickHK