use variables to specify a range

[nai0248]

This seems like a very simple question but I can't seem to find the answer....

How can I specify a range without knowing the range? A2 will always be the starting range and would like to use Range("A65536").End(xlUp).Select (or some other method) to find the last cell with text.

so...

Instead of Set x = Range("A1:A10")

Is there a way to use;

Range("A1:Range("A65536").End(xlUp).Select) or some other variant?

[watersev]

hi, nai0248, one of the options:

Set x = range([a1],[a65536].end(xlup))