Hi all ..
Have a macro that sorts Column B ascending from B5:B3005.
Data can be on any line within that 3000 line range as multiple users input in certain line ranges, so there are blank lines in between all data.
But when I sort ascending, ALL blank lines in between are pushed to the bottom .. all the data is listed in one long list.
When I go to sort it descending .. it puts all those blank lines at the top.
Any way I can remove the blank lines and still sort descending?
This is the code I use so far for the sort_descend
[vba]
Sub sort_descend()
'
' sort_descend Macro
' Macro recorded 04/01/2006
'
'
Range("B5:AF3005").Select
Selection.Sort Key1:=Range("B5"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Range("B5").Select
End Sub
[/vba]
Hope someone can help