sort using vba

The solution for “sort using vba” can be found here. The following code will assist you in solving the problem.

Sub SortDataWithoutHeader()
Range(“A1:B12”).Sort Key1:=Range(“A1”), Order1:=xlAscending, Header:=xlNo
End Sub

‘Key = start point, primary coloumn
‘Order = type of sorting
‘If yes, sorting with start Key+1 to avoid the header

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts