Hi Nick,

I've never tried this myself but Steven Roman in his WRITTING EXCEL MACROS
from O'Reily press list this:
Enum xlPTSelectionMode
xlDataandLabel = 0
xlLabelOnly = 1
xlDataOnly = 2
xlOrigin = 3
xlBlanks = 4
xlButton = 15
xlFirstRow = 256
End Enum
Roman warns this is Excel 9 only but you might give it a try anyway. His
book does have a lot of reference to constants. If you do a lot of
international work it might be worth having.

Regards,
Mike

"Nick O" wrote:

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