I am trying to use the getpivotable function within VBA but am unable to do
so..

Tried to use the following

application.worksheet.getpivottable

I get an error. I am able to use getpivottabledata within a worksheet as a
formula no problem..

Basically I am attempting to obtain summary information from a pivot table
and automating it within a Macro..


Regards,

Ray Pathak