| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stepping through Pivot table page field items with VBA
The pivot table I'm working with in Excel 2000 has a different number of page
field items each time I refresh the data. I'm trying to find the way to step through these, i.e. start with the first item then move onto the second item and so on. While I can set the Currentpage to a specific value e.g "LN2" can someone please tell me how to set it to the second item and then move on to the third etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependent page items in pivot table | Excel Discussion (Misc queries) | |||
| Data Field Items deleted when unchecked in Pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table - Dragging multiple items into data field | Excel Discussion (Misc queries) | |||
| Pivot Table - untick all items in row field | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Appends a '2' to the field data items | Excel Discussion (Misc queries) | |||
Threaded Mode
