Hi,

When trying to assign a value that doesn’t exist to a PivotTable page filter:

PivotTables(“PTName”).CurrentPage = MyValue
I’m getting an error. That’s fine.

What I’m trying to do is to force this filed to be blank, or any other solution so the PT will show no records.

Thanks,
Yonyon