Pivot Items Filter using VBA

G

Gaura215

Hello

I have a code which make a Pivot using VBA. however there is a conditio
that I am unable to fulfilled in that pivot using my VBA.

I will try to write it here the code I wish for.

ActiveSheet.PivotTables("PivotTable2").PivotFields_
("ReportTimeframe") .CurrentPage = "(All)"
With ActiveSheet.PivotTables("PivotTable2").PivotFields("Repor
Timeframe")
_____.PivotItems.*Last_Month*.Visible_=_True
____.PivotItems.*All_Other_Months*.Visible_=_False_
End With

I want a fix in my underline codes above.

Any help in this would be appreciable
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on Marcos 0
Several Pivot Tables: Change one filter and adapt it for the other 2
Macro Failure 6
Pivot Table Help 1
Playing back a Pivot Table macros 2
Automatically Update a Pivot Table Field Used as Column / Row 2
Pivot Table Macro Error - almost solved 2
Pivot Table Filtering - Macro 3

Top