| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link all dependent cells to a "new" independent cell?? | Excel Discussion (Misc queries) | |||
| Pivot Table - "duplicate dimensions across (independent) axes" | Excel Programming | |||
| Language independent Pivot settings | Excel Programming | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
| Pivotitems("(Blank)") in foreign language | Excel Programming | |||
Linear Mode
