Need to copy cells in a column until blank cell

[tdunlap2015]

I need to copy all cells in column A until a blank cell is reached and then paste off of them in another workbook in sheet 1, column B at the first blank cell in that column. Can anyone help me with this?

[NoSparks]

I need to copy all cells in column A until a blank cell is reached

does this mean what it says, that you have blank cells somewhere within the data of column A and want to stop the copy at that point, or do you mean copy all cells in column A down to the last cell with data?

The best way to get help with this would be to use the macro recorder to record you doing this manually. Then post the recorded macro for "tune up".

Be sure to use code tags when posting the macro.