You could use a dynamic range

http://www.contextures.com/xlNames01.html#Dynamic

You should have no problem sorting your list, just highlite the range
you want to sort and goto
data,sort, then pick column A as the first column


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=546655