How To Find Pivot Table Name

How to display tabular array or pivot tabular array name in a cell in Excel?

This commodity is talking near displaying a specified table or pivot table name in a jail cell in Excel.

Brandish table or pivot table name in a cell with VBA code

Display table or pivot table name in a cell with VBA code

Hot

The following VBA code can assist yous brandish a specified table or pin table name in a jail cell. Please do as follows.

i. Press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.

2. In the Microsoft Visual Basic for Applications window, click Insert > Module. And then re-create below VBA code into the Module window.

VBA code: Display table or pivot table name in a cell

Function getObjName(rng As Range) Equally String 'Updated by Extendoffice 20180420     Dim xTable As ListObject     Dim xPivotTable As PivotTable     Dim xTableName As String     Dim xPtName Equally String     On Error Resume Next     xTableName = ""     xPtName = ""     Ready xTable = rng.Cells(one).ListObject     xTableName = "Table[" & xTable.Proper noun & "]"     If xTable Is Nothing So         Gear up xPivotTable = rng.Cells(ane).PivotTable         xPtName = "Pivot [" & xPivotTable.Proper noun & "]"     Finish If     getObjName = xTableName & xPtName End Function

iii. Press the Alt + Q keys to exit the Microsoft Visual Basic for Applications window.

4. Select a blank prison cell, enter formula =getObjName(A2) into the Formula Bar and and so press the Enter key. Encounter screenshot:

Notes:

1. In the formula, A2 is the jail cell of the tabular array you want to brandish the name. You tin can reference any prison cell of the table range equally y'all need.

2. For displaying pin table name, please change A2 in the formula to any cell inside the pivot table.

How to listing all tabular array names in Excel?
How to continue table expandable by inserting table row in a protected worksheet in Excel?
How to reorder position of columns in tabular array in Excel?
How to hibernate zero value rows in pivot tabular array?

The Best Office Productivity Tools

Kutools for Excel Solves About of Your Problems, and Increases Your Productivity past 80%

Reuse: Quickly insert complex formulas, charts and anything that you take used before; Encrypt Cells with password; Create Mailing List and transport emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Split up Cells Content; Combine Indistinguishable Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Indistinguishable or Unique Rows; Select Bare Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without irresolute formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Excerpt Text, Add Text, Remove by Position, Remove Infinite; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (salve and utilize filter schemes to other sheets); Advanced Sort by calendar month/week/solar day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Information into Multiple Sheets; Batch Catechumen xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Like shooting fish in a barrel deploying in your enterprise or system. Full features 30-solar day gratuitous trial. 60-twenty-four hours coin back guarantee.

kte tab 201905

Role Tab Brings Tabbed interface to Office, and Brand Your Piece of work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

officetab bottom