Hi All,

I have a set of cells that I want to sort within a macro. I want these to be sorted ascending but some of the cells contain "" to enable me to have blank looking cells. When I sort the cells the ones with "" come before those beginnign with A. Is there a way to avoid this?

This is the code I have currently.

Range("B9:H43").Sort Key1:=Range("B9"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
Thanks
dvent