Macro for adding rows after previous row?

[xwishmasterx]

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?

[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.

[Marcol]

Using a convenient cell say "A1"

in ThisWorkbook

Please Login or Register  to view this content.

Insert in a standard module

Please Login or Register  to view this content.

Do you want to clear rows on opening workbook?

[xwishmasterx]

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

[shg]

Whether the row below has anything in it? What if it does?

[xwishmasterx]

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

[shg]

Please Login or Register  to view this content.

[Marcol]

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