View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick O Nick O is offline
external usenet poster
 
Posts: 1
Default Pivotitems("(Blank)") in foreign language

Is there an xl constant or standard name somewhere that defines whatever the
local version of "(Blank)" is?

I sent a vba pivot table to a colleague in Italy and it refused to behave
properly. The problem was eventually tracked down to a new pivot item called
"(Vuono)".

Since this has to go to places like Croatia, Malaysia and Russia, I think I
to find a generic method!

Same goes for "(All)"....

Many thanks,

Nick