Looping Through Pivots To Find Filter Caption

[NeedForExcel]

Hi,

PFA File attached.

I want to loop through all the Pivot Tables on the Workbook and display MsgBox for each Filter Caption.

In this case, the MsgBox should Display InvoiceDate.

Can anyone guide me how to do it?

[nilem]

Hi NeedForExcel,
try so

Please Login or Register  to view this content.

[NeedForExcel]

Perfect..

Marking the thread solved and adding rep..

BTW, what is the significance of the & in Dim i&

[nilem]

Dim i& is the same Dim i As Long

[NeedForExcel]

Oh yes, I had read about that long back..

Cheers!