All cells from the first in a range to the end of the sheet

[MLang]

I wish to select:
...all of the cells in a single column
...from the top-left cell in a specific range
...to the last cell in the used area of the spreadsheet in that column

All of the searches I have done lead to to other specific cases. Hoping someone can help.

Thanks!

 

[Tuelor]

Have you looked in to dynamic lists? There are a few good websites out there giving detailed advise on using dynamic lists - I would recommend searching for it in Google.

 

[Scott R]

Range("A5", Range("A9999").End(xlUp)).Select

Substitute whatever lower limit you think is necessary for "A9999".

Tables are a good alternative to bounding your data sets--you might look into that.