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