|
Language independent VBA - hiding "blank" in pivot?
PivotItem.Value = "(blank)"
How can I hide the blank in a pivot, if the VBA code has to be language independent? Example of the code I have: On Error Resume Next For Each pvtItem In pfR.PivotItems pvtItem.Visible = False If pvtItem.Value = "(blank)" Then pvtItem.Visible = False If pvtItem.Value = "" Then pvtItem.Visible = False Next pvtItem Kindest, Tyrone |
Language independent VBA - hiding "blank" in pivot?
hi Tyrone,
For Each pvtItem In pfR.PivotItems If pvtItem = "(blank)" Or pvtItem = "" Then pvtItem.Visible = False Else pvtItem.Visible = True End If Next pvtItem -- isabelle Le 2012-10-04 02:04, Tyrone Skogstrom a écrit : PivotItem.Value = "(blank)" How can I hide the blank in a pivot, if the VBA code has to be language independent? Example of the code I have: On Error Resume Next For Each pvtItem In pfR.PivotItems pvtItem.Visible = False If pvtItem.Value = "(blank)" Then pvtItem.Visible = False If pvtItem.Value = "" Then pvtItem.Visible = False Next pvtItem Kindest, Tyrone |
| All times are GMT +1. The time now is 11:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com