View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paolo Sardi Paolo Sardi is offline
external usenet poster
 
Posts: 6
Default How do I check Pivot Table existence?

Hi,

I'm trying to check if a pivot table named "MyPivot" exists in a given
worksheet.

I tried with:
If worksheets("Pivot").PivotTables("MyPivot") is nothing then...

Unfortunately Excel gives me an error, I think because it does not find the
PivotTables("MyPivot").

Is there a way to check if a PivotTable exists?

Thank you.