I'd use something like:

Dim PT as pivottable

set pt = nothing
on error resume next
set pt = worksheets("Pivot").PivotTables("MyPivot")
on error goto 0

if pt is nothing then
'nope
else
'yep
end if



Paolo Sardi wrote:

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.

--

Dave Peterson