how can I check in VB if a sheet is having a pivot table?

[WJvR]

I want to select a pivot table on an active sheet in an Excel Workbook, if
there is a pivot table in that active sheet.

How can I do that?

Thanks for helping

WJvR

 

[JE McGimpsey]

One way:

If ActiveSheet.PivotTables.Count > 0 Then
'Do Something
Else
'Do Something Else
End If

 

[WJvR]

that helps for sure, thanks!

but now is still my problem, how do I know, where the pivot table starts in
the sheet. Does anyone know how to go to the first cell in the pivottable?

WJvR

 

[Bob Greenblatt]

that helps for sure, thanks!

but now is still my problem, how do I know, where the pivot table starts in
the sheet. Does anyone know how to go to the first cell in the pivottable?

WJvR

How about
....pivottable.tablerange1.cells(1).address