Hi,

i am looking a way to find pivot range and refer to it.
Assume to first column, first cell.

It can be done by pivot name?
It is possible to do it?

i know that i can use OFFSET (volatile function - not for me) or index and sum but still i have to know where pivot table is...

edit: please move the topic to Excel Formulas subforum.

Best,
Jacek