Pivot with Custom Sort

[KDBrown]

Good day,

Using Excel 2007, I've successfully created the code needed to custom sort a pivot table when a particular field is selected as the first item in rows. Since this report will have multiple users, I've also coded to add the required custom list.

My problem...
The code calls the custom list via its position in the overall group of custom lists. Example: OrderCustom:=6. Since the report will have multiple users, the required list could be in any position.

Is there an alternative way of identifying which custom list to use?

Thank you!

 

[Jerry Sullivan]

You can use the GetCustomListNum Method...

n = Application.GetCustomListNum(Array("North", "East", "South", "West"))

This returns the CustomList number if found or 0 if not found.

 

[KDBrown]

Works perfectly! Thank you - greatly appreciate your help!