Thanks again for all the help in advance.


I am trying to select half a sheet and sort just that half. The sort
area wont always be the same exact size. Sometimes I'll need to sort
cells A20 - G418, and other times A21 - G418, or A22 .......

I know I can use a variable using cells to select a specific cell,
i.e., cells(counter,1) but I need to be able to use a variable to
select an entire range of cells.

Can someone explain to me the proper syntax for selecting a range like
cells(20,1) - cells(418,7) using cells instead of range?

Or perhaps, please explain to me how to select a Range using a
variable?

Either way would help me tremendously.

Thanks again for the help,

JasonK