I want to find the cell names for any heading in a pivot table e.g. F12 etc. Assuming a heading in the pivot is " Sales", I would like to get the cell where it is located e.g. F12.
I have tried using Worksheet.Cells.Find but this work only for the first pivot as there is no way of specifying the second pivot etc.
How can I get the cell name once I know the heading text (for any pivot on the worksheet)