| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
repositioning aging categories in a pivot when present
Hi,
I know how to reposition aging categories within a pivot by adding the following line: ActiveSheet.PivotTables("PivotTable1").PivotFields ("Aging").PivotItems( _ "Overdue").Position = 1 But my concern is that the macro won't work if a specific again categorie isn't available (no data in that categorie). How can this be solved with a if..then structure. Thanks in advance, Hans Weustink |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table categories | Excel Worksheet Functions | |||
| All categories to show in pivot tables for use as dataframe? | Excel Worksheet Functions | |||
| Pivot table aging report sort order | Excel Worksheet Functions | |||
| How to print different charts from multiple categories of pivot ch | Excel Discussion (Misc queries) | |||
| How I can add categories in a pivot table? | Excel Worksheet Functions | |||
Hybrid Mode
