Select First Active Cell if the cell is in a pivot table

D

Don

I have a macro that updates around 30 pivot tables.

It opens a worksheet, and runs a refresh (pivot table
cache) ...

it will fail with a properties not supported unless the
cell is positioned on a pivot table.

is there a way to posistion the active cell to the first
(top left) column of a pivot table?

Note: all pivot table names are PivotTable1

Thanks in advance

Don
 
Top