Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Remove the CalculatedItem by deleting it from either the CalculatedItems collection or the PivotItems collection of the PivotField.t
Sub DeleteCalculatedItem()
     With ActiveSheet.PivotTables(1).PivotFields("Product")
         .PivotItems("Melons").Delete
     End With
End Sub