Hi,
I want to hide the entire row in a pivot table in which the value(-s of that row is either zero, empty, or #NB.
In the beginning of the year there wuill be o1 value in the pivot table (month=1).
At the end of the year there will be 12 values in the pivot table (month=12).
I want to solve this using VBA but I don't know how.
Can someone help me with the VB code ?
I want to hide the entire row in a pivot table in which the value(-s of that row is either zero, empty, or #NB.
In the beginning of the year there wuill be o1 value in the pivot table (month=1).
At the end of the year there will be 12 values in the pivot table (month=12).
I want to solve this using VBA but I don't know how.

Can someone help me with the VB code ?