Get the selected pivot table name - Excel VBA

Question

I have two pivot tables on one excel sheet. I would like to know how do you get the name of a selected pivot table with Excel VBA?

I tried ActiveSheet.PivotTables.Selected, but this is not a supported property.

Rory · Accepted Answer · 2014-09-23 11:42:02Z

17

You simply use:

ActiveCell.PivotTable.Name

or, with a bit of error handling:

Dim PT as PivotTable
On Error Resume Next
Set PT = Activecell.PivotTable
On Error Goto 0
If not PT is nothing then msgbox pt.name

answered Sep 23, 2014 at 11:42

Rory

34.2k5 gold badges40 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1