Hi all,

Using Excel 365.
The code below returns an odd result : $F$6 - that is all.

If the DataBodyRange includes the the 2nd row of labels from the PivotTable, I would expect the address to be $B$6:$F$6.
However, I dont think the DataBodyRange should include any of the labels from the Header Row, just any data row that are visible.

In this case, there are no visible data rows, they are all filtered by the Page Filters - so I would expect nothing from the code or maybe an error.

Any thoughts here?

Thanks,
-w

Please Login or Register  to view this content.