Language independent VBA - hiding "blank" in pivot?

  • Thread starter Tyrone Skogstrom
  • Start date
T

Tyrone Skogstrom

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
 
I

isabelle

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to set pivotitem.visible property to true 5
Select Text to End of Footnote 9
VBA Export to PDF 0
PivotTable: How to reset the CurrentPage to (All) 0
Dealing with a Pivot Table (when I don't want to) 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How to cycle through displayed PivotItems instead of the VisibleItemscollection 2
Change report firlds in pivot tables and charts with one selection 0

Top