Double Click Active Cell

[tobermory]

Hello,

I need a vba code that will double left click the cell that is currently selected, i.e. the active cell.

Is this possible?

Thanks very much in advance for any assistance.

 

[My Aswer Is This]

Tell us why you would want to do this.

It seems a lot easier to just double click a cell then to click on a cell and then use a shortcut key to do a double click

 

[tobermory]

At work we have a spreadsheet with a mass of data, all in pivot tables. If you double click on a cell it opens up another sheet that brings up data specific to that cell.

It has to be the active cell as the main pivot table changes specific rows/columns fairly frequently.

The code is part of a bigger code that requires a lot of double click of the pivot table.