how to manipulate Pivots - VBA?

[mortphil]

Hello everyone,

At the moment, I refresh a number of pivots by selecting a range where the pivots is located (which activate the pivot) then I refresh it.

I am sure there is a better way to refresh specific pivots? (I know, it's a trivial one, but it would really be helpful)

Thanks for your time,

-Philippe

[mikeTRON]

That is a google question my friend.

ActiveSheet.PivotTables(1).PivotCache.Refresh

No need to select cell A10.

ThisWorkbook.RefreshAll

<-- I usually use that to update them all

More info:
http://www.ozgrid.com/VBA/pivot-table-refresh.htm

[mortphil]

Thanks, MikeTron.