vba sort the data Z to A
Sub sbSortDataInExcel()
'Delcaring the strDataRange as range store the target range to sort
Dim strDataRange As Range
'Delcaring the keyRange as range store the Sort key range to sort by
Dim keyRange As Range
'Assigning the target sort Range to strDataRange
Set strDataRange = Range("A1:D10")
'Assigning the sort key Range to keyRange
Set keyRange = Range("A1")
'Sorting the data using range objects and Sort method
strDataRange.Sort Key1:=keyRange, Order1:=xlAscending
End Sub
4
3
Sub sb_VBA_Sort_Data_Ascending()
Range("A1:D10").Sort _
Key1:=Range("A1"), Order1:=xlAscending
End Sub
Thank you!
3
4
(3 Votes)
0
Are there any code examples left?
New code examples in category VBA
Relative searches
sort column vba
sorting a table in excel vba
single line code to sort a table in excel vba
sort vba
sorting column vba
excel vba application.sort
sort mulitple selection range vba
writevba code for entire sheet sort
sort ascending in excel vba
excel vba sort usedrange descending
excel vba sort
sort in vba
sorting vba
macro to sort data based on criteria
ORDER EXCEL VBA
excel macro sorting
vba sort column alphabetically
vba sort column
vba sort
excel vba sort table smallest to largest
vba code to sort data
vba sort selection by column
sort a column ascending vba
sort ascending in vba
how to sort columns vba
vba sort column data
vba filter accending
how to sort ascending in vba
sort items in one cell in excel macro
vba sort the data smallest to largest
make excel macro to sort a list of paste
exel vb sort table
vba sort the data Z to A
