Viewing VBA Code For PivotTable ?

[moonbase]

Hi,

Is it possible using the Visual Basic editor to view the code for a PivotTable in a worksheet? I have opened up the editor and double clicked the name of the sheet that contains the PivotTable but the code window is blank. I can see the General and Declarations drop down options in the code window but there is no code representing the PivotTable.

Is this possible and am I looking in the wrong place, or, is it not possible?

Any advice most appreciated.


Rgds

 

[Norie]

There isn't really any code associated with a pivot table.

A pivot table is an object on a worksheet.

You can refer to it in code.

How you do that depends on what you are trying to do.