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:
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?