PDA

View Full Version : How to select changing cells within a column



truzilla
06-09-2008, 09:28 AM
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! :hi:

Bob Phillips
06-09-2008, 10:00 AM
Range("A16").End(xlDown).Select


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

truzilla
06-09-2008, 10:04 AM
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
06-09-2008, 10:33 AM
Range(Range("A16"),Range("A16").End(xlDown)).Select

truzilla
06-09-2008, 11:03 AM
super, thanks!!