Macro to copy rows from 1 sheet into the next blank row on a different sheet

You should edit your post and use the code tags as required by the forum rule number 3

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.

Please Login or Register  to view this content.

Sorry about that - I fixed my original post. Thanks for your help, this worked perfectly.