There are a lot of ranges in those pivottables. Glad you found the one you
wanted.

Carim wrote:

Dave,

Thanks to your insight, I have discovered I had to dig into the pivot
table Object...
Next to DataBodyRange which includes all data, there is, for example :
.RowRange.Columns(1).Cells
to select data subsets ...

Thanks again for your precious help
Cheers
Carim

--

Dave Peterson