Hi.

When I sort a selection by a column that contains blanks the rows with
blanks always sort to the end regardless whether I set ascending or
descending. Is there anyway to reverse this?

Selection.Sort Key1:=Range("B11"), Order1:=xlAscending, Key2:=Range("M11"
_
), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=
_
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal,
DataOption2 _
:=xlSortTextAsNumbers

Column B contains a either 'X' or ''
Column M contains a number

and I want the rows with an 'X' at the bottom of the list.

TIA Steve

PS Using Office 2003 pro