ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   getpivotdata problem (https://www.excelbanter.com/excel-programming/376585-getpivotdata-problem.html)

watkincm

getpivotdata problem
 
I am trying to calulate a field based on pivot data...
Can anybody tell me why this results in an "Application defined or object
defined error"

ActiveCell.Offset(0, 1).Select
ActiveCell.Value = 1.2
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = _
"=GETPIVOTDATA(""2006
F/cast"",$B$11,""Geo"",""Americas"",""Region"",""Cen tral"",""Partner Type"","
& gpde & ",""Fulfillment"",""Rev Ptnr."")*(RC[-1])"

(""2006 F/cast") is a CalculatedField
--
Mike Watkins


All times are GMT +1. The time now is 03:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com