Pivot Field VBA Question

[john432]

I'm sure there is a very simple solution to this. I'm trying to use user input to limit field visibility in a pivot table.

Say I want "Asia" which is written in cell(1,1) to be removed from calculation when it occupies cell(1,1) I have written my code as follows.

Sheets("PivotSheet").Select
With ActiveSheet.PivotTables("BudgetPivot").PivotFields("DIVISION")
.PivotItems(Cells(1, 1)).Visible = False

I get an error that Excel is unable to locate the Pivot Field even though it reads the cell(1,1) reference as being "Asia"

Solution?

[T-J]

This is one way, walking through the PivotItems Collection of the DIVISION field:

Please Login or Register  to view this content.