WOODY_GOODWOOD
New Member
- Joined
- Apr 12, 2013
- Messages
- 4
what i would like to do is when i do sorting the cells that contains letters go to the bottom leaving the cells that contains numbers on the top.
this is the code i use:
Range("A3:E20").Select
Selection.Sort Key1:=Range("E3"), Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("I12").Select
<colgroup><col></colgroup><tbody>
</tbody>
this is the code i use:
Range("A3:E20").Select
Selection.Sort Key1:=Range("E3"), Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("I12").Select
DQ |
DNS |
80,00 |
32,10 |
32,00 |
31,51 |
31,50 |
03,00 |
<colgroup><col></colgroup><tbody>
</tbody>