Check if pivot already exist
 

If activesheet.pivottables.count 0 then
' pivot table exits
End if

--
Regards,
Tom Ogilvy

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!