I record a macro (see attached workbook) to sort a range and I get asked a question about whether I'd like to sort anything that looks like anumber, as a number, or to sort numbers and text separately. I choose the former and get this macro:
Sub Macro3() Range("A1:D11").Select Selection.Sort Key1:=Range("C2"), Order1:=xlDescending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortTextAsNumbers End Sub
I want the result that I get on the sheet as I'm recording the macro (as in the attached). When I run the macro, it seems to ignore the
DataOption1:=xlSortTextAsNumbers bit while resulting in what seems to be a normal sort, which is not what I want.
This applies to Excel 2002 and 2003, under XP.
Am I missing something?