Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getpivottable function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getpivottable function
GetPivotData is a method of the PivotTable, and there's an example in
Excel VBA help: '================ Sub UseGetPivotData() Dim rngTableItem As Range ' Get PivotData for the quantity of chairs in the warehouse. Set rngTableItem = ActiveCell. _ PivotTable.GetPivotData("Quantity", "Warehouse", "Chairs") MsgBox "The quantity of chairs in the warehouse is: " _ & rngTableItem.Value End Sub '===================== Raypat wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i do a getpivottable | New Users to Excel | |||
getpivottable function? | Excel Worksheet Functions | |||
Can i pull text with a Getpivottable formula? | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming |