Macros: find and start at 1st blank row

Hello,

I have a Macro that will copy data in the cells of a particular worksheet in a particular open workbook into those of another workbook.

At the moment I have it hard coded into the code where I want the data to start copying into (1st destination row). I would like the macro to simply recognise which is the next blank row in the destination worksheet and start copying to there.

Here is a sample of the code:

--------------------------------------

Please Login or Register  to view this content.