Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
we have a pivot table.
The dimensions have enable conditional expressions to be shown or not, based on the condition.
Works fine.
Now we need to find out in a macro,
if a condition is true or even better, if the dimension is shown.
Is there an easy way to do that?
If not I would have to read the EnableCondition.Expression and try to analyze it.
We need to do that,
because we want to check cell values, but only for the dimensions,
which are shown (condition = true) in the pivot table.
Roland
Hi,
solved... we went the hard way, by analyzing the condition.
Roand