Find first empty row and paste into it

Hey guys,

I am trying to copy a selection (B13:B21) from one sheet called 'horizontal full list' and paste it into 'sheet1' into the first blank cell in column B from cell B15 onwards. The code I am trying to use is:

Please Login or Register  to view this content.

But this is getting errors & I know it isn't complete i.e. to paste from cell B15 onwards.

Could anybody offer me any help with getting this sorted?!

Thanks,
Alex

You could do it like so:

Please Login or Register  to view this content.

Thanks Stephen, that works perfectly!!