Excel Vba Sort Using Custom List. Let's take an example and understand how we can make the custom sort list and how we can use it. Optionally, you can create your own custom lists to sort by any other characteristic that doesn't sort well alphabetically—such as high, medium, and low—or S, M, L, XL.
Where Range specifies the range of cells which we want to sort out in ascending or descending We will learn how VBA Sort can be used to sort the column without headers, a column with headers and Multiple columns with examples in excel.
Custom Lists are specifically useful in sorting, in cases where you want sorting to be done in a customized order.
Type the items in the desired custom order in the List entries: box. Sorting : In Excel Sorting can be done easily manually. Browse other questions tagged vba or ask your own question.








