Hi,
This should be an easy one,
Can someone help me with why this script isn't working.
It is suppose to remove the (blank) check mark from the activesheets pivot table.
I'm getting a (Object doesn't support this property or method)
Thanks as always for your help...![]()
Sub removeblanks5() Sheets(1).Select With Sheets(1).PivotTables.PivotFields("Name") .PivotItems("(blank)").Visible = False End With End Sub
Mike
Bookmarks