PivotTable VBA

[DanKay1]

Is there a PivotTable function or solution which returns starting location of each pivottable in the worksheet?

Thanks,
Dan.

 

[SkipVought]

Hi,

Take a look at the PivotTable TableRange1 & TableRange2 properties.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[DanKay1]

Thanks it worked. One more question. Is there a way to get the first column position within pivot table?

Thanks for your help.

 

[SkipVought]

PivotColumns

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]