Pivot Table Filtering

[speth]

I'm having trouble filtering what's in a pivot table using VBA. I have a large pivot table, but for sake of brevity, the attached sample is essentially the same thing.

In this sample, I'm getting kicked back with a 1004 error that it can't find the referenced PivotField. Here's the code....

Sub PIVOT_TEST()
Sheets("Sheet2").PivotTables("PivotTable2").PivotFields("Number")PivotItem("4").Visible = False
End Sub

Here's the data that's sent to the pivot table. The VBA is running after the table has been created (Sheet2).

Number	Name
1	Bob
2	Jim
3	Sam
4	Bill
5
6	Ted
7	Amy
8	Becca
9	Josh
10

<tbody>
</tbody>

Any suggestions?

 

[steve the fish]

Doesnt seem anything wrong with the code. Check spelling etc. Record the action and see if yours looks like the recording.