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