ExcelBanter - autosort

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - autosort (https://www.excelbanter.com/excel-programming/413962-autosort.html)

Anthony

autosort

autosort leaving blanks where they are left to right

Ranjit kurian

autosort

Hi Anthony,

Try the below code

Sub sortme()
Cells.Select
Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

"Anthony" wrote:

autosort leaving blanks where they are left to right

All times are GMT +1. The time now is 12:53 AM.