Thread: Language independent VBA - hiding "blank" in pivot?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tyrone Skogstrom Tyrone Skogstrom is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote