Macro for adding rows after previous row?

I have this simple macro which copy row 17 and paste it to row 18:

Code:

Please Login or Register  to view this content.

How can it be written so if I run it again it will copy from row 18 and paste to row 19?

Also, if I close and open the workbook again, will it start over from row 17?

Originally Posted by shg

Maybe like this. Note that the row copied is the top row of the current selection.

Please Login or Register  to view this content.

That works great! Now I just need to figure out if it can "detect" weather or not the row already has content ( to avoid overwriting other content)

thnx

well, if the row below has anything in it it should not paste! rather open a msgbox with some text.

Thought there had to be more than the original post suggested.
Otherwise why not just use Ctrl+D.