How to select changing cells within a column

[truzilla]

Hi, I basically need help selecting a column from a range that has a changing number of cells.

For example, if cells 5 through 20 are filled in column a. I need a macro that will select those cells so I can copy them to another sheet. The problem is that the next time it could be cells 5-24 filled etc. I know the range will always start at cell A-16 but the end can change.

I hope that explanation was clear enough...Thanks for your help in advance!

[Bob Phillips]

[vba]

Range("A16").End(xlDown).Select
[/vba]

but there is unlikely to be a reason to need to select a cell.

[truzilla]

thanks for the response, but what if I want to select all the data between A16 and the end of the range? (the cell selected after applying your code "Range("A16").End(xlDown).Select ")

Thanks!

[Bob Phillips]

[vba]

Range(Range("A16"),Range("A16").End(xlDown)).Select
[/vba]

[truzilla]

super, thanks!!