I am trying to sort a range in my worksheet.
I create a worksheet pulling data from other spreadsheets. I go through a
directory and advance rows by using x+1. At the the end I don't know how
many rows I have and I don't want to hard code it. How do I use a variable
in the Range expression.
I only know

Range("A6:AT255")

Thanks

Range("A6:AT" & x)

0r
Range("A6:AT" & x + 1)

also

Range(cells(6,"A"),cells(x,"AT"))

or x + 1 of course.


--
Regards,
Tom Ogilvy

"ibbm" wrote:

I am trying to sort a range in my worksheet.
I create a worksheet pulling data from other spreadsheets. I go through a
directory and advance rows by using x+1. At the the end I don't know how
many rows I have and I don't want to hard code it. How do I use a variable
in the Range expression.
I only know

Range("A6:AT255")

Thanks

Can you pick out a column that always has data?

Dim LastRow as long

with activesheet
lastrow = .cells(.rows.count,"A").end(xlup).row

.range("a6:At" & lastrow).sort...

end with



ibbm wrote:

I am trying to sort a range in my worksheet.
I create a worksheet pulling data from other spreadsheets. I go through a
directory and advance rows by using x+1. At the the end I don't know how
many rows I have and I don't want to hard code it. How do I use a variable
in the Range expression.
I only know

Range("A6:AT255")

Thanks

--

Dave Peterson

awesome thanks

"Tom Ogilvy" wrote:

Range("A6:AT" & x)

0r
Range("A6:AT" & x + 1)

also

Range(cells(6,"A"),cells(x,"AT"))

or x + 1 of course.


--
Regards,
Tom Ogilvy

"ibbm" wrote:

I am trying to sort a range in my worksheet.
I create a worksheet pulling data from other spreadsheets. I go through a
directory and advance rows by using x+1. At the the end I don't know how
many rows I have and I don't want to hard code it. How do I use a variable
in the Range expression.
I only know

Range("A6:AT255")

Thanks

great idea, thanks.

"Dave Peterson" wrote:

Can you pick out a column that always has data?

Dim LastRow as long

with activesheet
lastrow = .cells(.rows.count,"A").end(xlup).row

.range("a6:At" & lastrow).sort...

end with



ibbm wrote:

I am trying to sort a range in my worksheet.
I create a worksheet pulling data from other spreadsheets. I go through a
directory and advance rows by using x+1. At the the end I don't know how
many rows I have and I don't want to hard code it. How do I use a variable
in the Range expression.
I only know

Range("A6:AT255")

Thanks

--

Dave Peterson