I am looking to create a macro that will take a range I have manually selected and paste is in the next empty cell in column A until row 2000.

Can someone help?

Thanks