Dinamic range name applied to a pivot table column

[drom]

Hi and thanks in advance!!!

I have a pivot table which data source is a table

• The pivot table's name is Pv01
• The DataSource's table name is Table1

According to the Pivot Table's Fields, my PT contains:

• No Filters
• No Columns
• 2 different Rows with many rows
• ∑ Values over 7

My Pivot table may contains Grand Totals but not always

If I use my mouse and I select my first column within this pivot tabble ans or if I use VBA like:

activesheet.pivottables(1).PivotFields(8).DataRange.select

I will select the range $J$11:$J$23

• Now is any way of applying a dinamic range to this range ??

because now the range is $J$11:$J$23
but tomorrow maeby $J$11:$J$520

When working with table's the names applied to columns withing the table are dinamic and fantastic but do we have the same possibility working with pivot tables ??

I can USE a dinamic range using Offset

But With Pivot table's do we have this possibility ??

Or I have to Use Dinamic ranges using Offset($J$11,0,0,counta($K$11:$K$11000),1)

Thanks again