How do I define a range of cells without using the "Range" property

[bananajelly]

I need to sort an entire worksheet going from Columns A to J, and from Rows 2 to n. "n" is a variable that represents a number that will change from time to time.

For now, let's just say that n=10. But it can be anything like 12, 14, 20, 100, etc. It will change every time.

I can't just use Range("A2:J10"), because it will not always be J10. It might be J12, J14, J20, J100, etc. I can't use Range("A2:Jn").Sort, because it doesn't recognize "n" as a number there. There is no such thing as Range.(Cells(2,1):Cells(10,n)).Sort

What else can I use besides the Range property to select an entire range of cells?

Range("A2:J_").Sort Key1:=Columns("A")

[shg]

Please Login or Register  to view this content.

[bananajelly]

Thanks. I actually found out that Range(Cells(2,1),Cells(10,n)).Sort also works. But now I'm having trouble sorting because of something else. The text I have to sort in ascending order are similar to the following:

01A010
02A012
01A015
01A004

I didn't format them as "text," but maybe excel does so automatically.

It should be sorted such that the order is

01A004
01A010
01A015
02A012

[shg]

Sorts fine for me exactly as copied from your post. Make sure you don't have any spurious spaces or other characters.

[bananajelly]

Thanks shg. I just switched the columns and rows :P.