Pivot Table - how do I get the name of the current table

F

Fred

Simple really, how do I find the name of the pivot table I have just
selected ?

I've tried various combinations of pivottable(s).name and got nowhere.

Thanks and regards
Fred
 
D

Debra Dalgleish

ActiveCell.PivotCell.Parent
Simple really, how do I find the name of the pivot table I have just
selected ?

I've tried various combinations of pivottable(s).name and got nowhere.

Thanks and regards
Fred
Click to expand...
 
Top