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!