View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
darkblue darkblue is offline
external usenet poster
 
Posts: 35
Default Pivot page field

Found it !

Sub Tester10()
With ActiveSheet.PivotTables("PivotTable1")
Debug.Print .PageFields(1).CurrentPage
.PageFields(1).CurrentPage = ActiveSheet.Range("c1").Value
Debug.Print .PageFields(1).CurrentPage
End With
End Sub


Thanks Tom.