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:
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: