Hi,

I am trying to write a macro to do a custom sort. I have writen part of
it which enters a custom list then it moves to the data I want to sort
and it is supposed to sort it in the order of the custom list. My
problem is I can't get the macro to choose my custom list which is at
the bottom of the custom lists. Below is the code.

Sheets("Customers").Select
Range("A3").Select
Selection.Sort Key1:=Range("A3"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=12, MatchCase:=False, Orientation:=xlTopToBottom

Thanks.

nb. Using Excel 97

James


--
fugfug
------------------------------------------------------------------------
fugfug's Profile: http://www.excelforum.com/member.php...o&userid=24950
View this thread: http://www.excelforum.com/showthread...hreadid=386709