Please can anyone help? I would like to hide PIVOT row entries featuring a specific substring as part of the text string for that entry.
By using the following code, I can specify the name of a full entry to be hidden:
I would like to hide any entry featuring the following substring (which always starts from position 1): "UK_CORP_MASK_".
I have tried using the InStr function in place of the specified name, but this crashes the code.
Please can anyone suggest a solution.
By using the following code, I can specify the name of a full entry to be hidden:
PHP:
With ActiveSheet.PivotTables("PivotTable1").PivotFields("SPECIFIED FIELD") .PivotItems("PRIVATE LABEL").Visible = False End With
I would like to hide any entry featuring the following substring (which always starts from position 1): "UK_CORP_MASK_".
I have tried using the InStr function in place of the specified name, but this crashes the code.
Please can anyone suggest a solution.