VBA Sorting Range

[doctorcpu]

Help sorting range using vba. I'm trying to sort two columns with formulas which has blanks as the result of the formulas. I'm trying to sort so that the blanks in the range are at the bottom and the sort is on cost highest to lowest. See example below

Any help is appreciated.
-------------------------Example--------------------------------

Before Sort After Sort QTY Cost QTY Cost 6 126.25 4 127.19 5 123.83 6 126.25 7 122.46 5 123.83 11 113.97 7 122.46 10 121.19 9 120.59 8 119.53 3 115.27 11 113.97 1 112.8 10 121.19 2 3 115.27 4 127.19 9 120.59 2 8 119.53 1 112.8 <tbody> </tbody>

<tbody>
</tbody>

 

[davesexcel]

If you sort by column A first, let excel expand to column B when you click the sort button.
This will remove all the spaces in column A,
Then sort by column B, letting excel expand to column A