Posted By: Anonymous
I have a table that can contain any number of rows:
As I said it can contain 1 or ∞ rows.
I want to sort range
A3:D∞ by the Date cell that is in column B.
How can I do it?
The problem is that I don’t know how to select from
A3 to the last row.
I think that looping to the last row is not a correct method.
I have got this so far it sorts looks like correct, but the range is hard-coded.
How do I get rid of the hard-coding of the range?
Range("A3:D8").Sort key1:=Range("B3:B8"), _ order1:=xlAscending, Header:=xlNo
Try this code:
Dim lastrow As Long lastrow = Cells(Rows.Count, 2).End(xlUp).Row Range("A3:D" & lastrow).Sort key1:=Range("B3:B" & lastrow), _ order1:=xlAscending, Header:=xlNo