Check if pivot already exist
 

activesheet.pivottables.count will tell you if there is zero or more

Cheers,
Paul Wright

sapta wijaya wrote in message ...
Dear all,

how to check if a pivottable already exist on
a sheet ?

thank in advance
sapta



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!