No, that is the way to do it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"saybut" wrote in
message ...

Hi, sorry I've just figured out how to do it.

Just in case anyone is interested, if you're sorting five columns,
A,B,C,D,E

sort the last three first, C,D,E and then sort A,B.


or if anyone has any better ways let me know.

thanks.


--
saybut
------------------------------------------------------------------------
saybut's Profile:
http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=514329