refering to Pivot Tables

  • Thread starter Thread starter KT Doan
  • Start date Start date
K

KT Doan

If cell A3 is part of a pivot table, is it possible to
reference the table without knowing the name or index?

If not, how do I obtain the name or index of a table if I
only know it's location on a sheet?

I can set the name for a table:
ActiveSheet.PivotTables("PivotTable2").Name
= "MyPivotTable"

But I don't know or have control over the existing name
(in this case, PivotTable2).

It appears that the default name of the table is a
sequential number based on the number of tables created in
the same Excel session.

Thanks in advance for any assistance.
 
?activecell.PivotTable (PT default property is name)
PivotTable1

?activecell.PivotTable.Tablerange2.Address
$A$3:$C$27

dim pt
set pt = Range("a3").pivottable



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Playing back a Pivot Table macros 2
Automatically Update a Pivot Table Field Used as Column / Row 1
Using macro to switch 'page' in a pivot table? 1
Variable column names and ranges in Pivot Tables within macros. 3
Rename a worksheet to use with a pivot table 1
Avoiding an extra sheet when creating a pivot table 3
VBA Pivot Table Error 1
reset pivot table name 4

Back
Top