copy/paste macro to selected blank cells

Im trying to record a macro to Copy the values in 11 specific adjacent cells in a column on one worksheet and Paste them into the first 11 blank cells in Column A of another worksheet in the same workbook. I want to be able to run this macro repeatedly as blank cells on the second worksheet are filled.

Currently, my macro selects and Copys the cells on the first worksheet and uses the FIND function to locate the first blank cell in Column A of the second worksheet. But at this point I have to intervene and click on the blank cell that has been found on the second worksheet before I can Paste. How can I make this macro complete the Paste without the need to have me intervene? I'm using Excel 2003. Thanks.

Hi
this will return the first blank cell in the first column in Sheet1

Please Login or Register  to view this content.

Thanks NickyC

How do I designate the blank cell that has been returned as the active cell?

jeffrey,

The 11 cells I am copying are always the same cells. Only the destination changes.

Jeff,

Your sample worked great. Thanks so much. This thread is solved.

fumc