Excel: Copy cell to first BLANK cell in column, NOT the first blank cell from the last row used

Hi, Please help me create a VBA code. I have been googling for a long time and the solutions it provides is not quiet what I need. I would like to copy a cell and paste into FIRST BLANK CELL in column B. Column B is a long column of data and it has gaps. So the cell I select needs to be copied into the first BLANK gap in column B. All the solutions seem to paste it at the bottom of column B after the last non-blank cell. Thank you! James

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of September 17, 2016.

For more resources for Microsoft Excel