VBA code to repeatedly copy and paste selection

i have this code:

Please Login or Register  to view this content.

To copy rows and paste them directly below. However, i would like this process to repeat itself to row whatever.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Getting an error with this line now:

Please Login or Register  to view this content.

Thank you John H. Davis that code works

You're welcome. Glad to help out and thanks for the feedback. Please comply with the Forum Rules and mark this thread as solved.

http://www.excelforum.com/forum-rule...rum-rules.html

I notice one issue with the code. It does a great job of coping everything including formulas but starts to act funny when i start putting in condition formatting.
If i have conditional formation on a cell in row 2, i get a debug warning and excel freezes up. Ive only noticed this with conditional formatting and nothing else.

Solved it.
Needed this line of code:

Please Login or Register  to view this content.