Thread: Double click in cell using VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
William Benson William Benson is offline
external usenet poster
  
Posts: 121
Default Double click in cell using VBA
You need to select the range you are trying to double click, like

Worksheets("Sheet1").Activate
activesheet.range("A6").select

Then call Application.Doubleclick

"Vuka" wrote in message
...
I require to double click in a cell with VBA code. The excel help explain
the following: Worksheets("Sheet1").Activate
Application.DoubleClick
This however do not work.

Can someone help?


Reply With QuoteReply With Quote