How to specify the variable end of the range to copy in a macro.

How can we tell excel to copy till the last row that has data in a worksheet and then whilr pasting it in different worksheet , paste it in the first row that is empty.

Thanks