Pivot Table - how do I get the name of the current table
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 |
Pivot Table - how do I get the name of the current table
ActiveCell.PivotCell.Parent
Fred wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Pivot Table - how do I get the name of the current table
Hi Debra
Thanks for the tip, obvious, when you know where to look :-) regards Fred |
All times are GMT +1. The time now is 12:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com