Thread
:
Accessing data in pivot tables
View Single Post
#
2
Posted to microsoft.public.excel.programming
Debra Dalgleish
external usenet poster
Posts: 2,979
Accessing data in pivot tables
What are you trying to pull from the pivot table? There's also a
GetPivotData method that you can use, following the examples in Excel's
Help.
If you want to record a macro without using the GetPivotData function,
you can turn it off. There are instructions he
http://www.contextures.com/xlPivot06.html
wrote:
Hi, I'm trying to access data sitting inside a pivot table. When I
record a macro, it uses the GETPIVOTDATA function.
ActiveCell.FormulaR1C1 = _
"=GETPIVOTDATA(""MR#"",R10C2,""Biopsy Year"",1993,""family
hx2"",""U"")/GETPIVOTDATA(""MR#"",R10C2,""Biopsy Year"",1993)"
Is there a more direct way to access the data without having to set the
value within another cell?
David
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Reply With Quote
Debra Dalgleish
View Public Profile
Find all posts by Debra Dalgleish