Guys i am using the following code. IT is throwing me errors. Please advise


Sheet11.PivotTables("GraphPivot1").PivotFields("Field1").CurrentPage = Sheet4.Range("pivotfield1").Value