ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   repositioning aging categories in a pivot when present (https://www.excelbanter.com/excel-programming/307433-repositioning-aging-categories-pivot-when-present.html)

Hans Weustink

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