Pivot Table Last row/column

[merlino]

Hi guys,

How do I find the last row/column of a pivot table's data section?

Thanks in advance.

Ian.

[DonkeyOte]

Not sure I follow exactly... maybe:

Please Login or Register  to view this content.

Should return the address of the last cell in the DataBodyRange... but not sure if that's what you want ?

Or if you prefer to not set the object etc you could just use:

Please Login or Register  to view this content.