[Excel]

Is it possible to hide rows in a PivotTable using conditional logic via VBA? If so what command should I be focusing on?

In VB .net through a COM object it is

Table.pivotfields(YOURFIELDNAME).pivotitems(ROWTOHIDE).visible = false

I dare say VBA will be very similar, it not the same.

Is there any way to do this through an If statement? I tried and If resourcename = " (rolled off)" then Visible = False and it didn't want to work.

Quote:

---

If resourcename = " (rolled off)" then Visible = False

---

you do not specify what object to make visible