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.