Select all data in a column that has blank cells
Posted on 2014-02-22
I have a macro that copies a column from one sheet to another.
Column A has no blanks but column B does.
When I use the following to copy, it only selects data down to the first blank cell instead of the entire column.
Application.CutCopyMode = False
I'm guessing the best way is to set a "range" which would be the number of rows with data in column A, then use that range value to copy columns that have blank cells but haven't found a good useable example googling.
Thanks in advance,