G Guest Jun 9, 2007 #2 Chip Pearson has the solution for you: http://www.cpearson.com/excel/sortws.htm