![]() |
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 |
All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com