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


"KT Doan" wrote:

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.