The problem is sometimes I don't have names in Order.

Herbert Seidenberg wrote:
In case you become interested in a
non-VBA solution:
Add a column with the formula
=IF(Subject="Tom",1,2)
and sort by that.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200712/1