best way to get reference to all used cells
 

I was using the macro recorder to see how to use the range.sort
function. When I did, I got something like:

Range("A1:J235").Sort Key1:=Range("A1"), Order1:=xlAscending

I should always know the number of columns but the number of rows will
vary. What's the best in code of coming up the "A1:J235"?

Thanks,
Woody

best way to get reference to all used cells
 

Hi,

lastrow=Cells(rows.count,"A").end(xlup).row

Range("A1:J" & lastrow).Sort Key1:=Range("A1"), Order1:=xlAscending

HTH

"sugargenius" wrote:

I was using the macro recorder to see how to use the range.sort
function. When I did, I got something like:

Range("A1:J235").Sort Key1:=Range("A1"), Order1:=xlAscending

I should always know the number of columns but the number of rows will
vary. What's the best in code of coming up the "A1:J235"?

Thanks,
Woody

best way to get reference to all used cells
 

thanks, I forgot you can concatenate strings and numbers without any
effort.