Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot page field
My pivot page field resides on B1.
I'd like to put a validation list on cell C1 or D1 and use that cell instead of pivot page button. I just don't like the pivot combo list. Is it possible at all to sync ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Page Field | Excel Discussion (Misc queries) | |||
Page Field on Pivot Charts | Charts and Charting in Excel | |||
Pivot Table Page Field | Excel Programming | |||
Pivot Page field value not shown | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Programming |