VBA to filter blank rows in a Pivot table

[SanjayGMusafir]

Hi Experts
I'm using following code to filter blank rows. The code deals with two Pivot tables simultaneously based on a same table.
But the code is not filtering blank rows.
Please help
Thanks a lot

'To Filter Blank Records
    On Error Resume Next
    With ActiveSheet.PivotTables("MFPlan").PivotField("Name").PivotItems("(blank)").Visible = False
    End With
    With ActiveSheet.PivotTables("MFAnalysis").PivotField("Plan").PivotItems("(blank)").Visible = False
    End With

 

[Domenic]

Try it without the With/End With statements, and it should be PivotFields not PivotField...

    ActiveSheet.PivotTables("MFPlan").PivotFields("Name").PivotItems("(blank)").Visible = False
  
    ActiveSheet.PivotTables("MFAnalysis").PivotFields("Plan").PivotItems("(blank)").Visible = False

Hope this helps!

 

[SanjayGMusafir]

Thanks @Domenic it worked

 

[Domenic]

You're very welcome, glad I could help.

Cheers!