Writing a Macro that allows you to Sort an indefinite amount of rows

[mumair]

Right now I have a macro which will sort a specific selection of rows the way I want them which is great:

Sub Sequence()
Range("B20:S24").Sort key1:=Range("J20:J24"), _
order1:=xlAscending, key2:=Range("M20:M24"), _
order2:=xlDescending, Header:=xlNo
End Sub

However, I might need to enter more data or less data than the 5 rows I have in the macro already. I want the macro to be robust enough for a user to enter any amount of records and be sorted correctly. Any thoughts on how to make my macro more general?

[xladept]

Maybe:

Please Login or Register  to view this content.