How to copy/insert new row into worksheet?

[Crüe]

Hello,

I'm using this macro-code to insert new rows into worksheet

Please Login or Register  to view this content.

It copies row 6 and inserts it down to row 7.

I need to modify this code so that it copies both row 6 and row 7 and then inserts copies down to rows 8 and 9, or something like that. Rows 6 and 7 needs to be copied and new copies needs to be inserted below. is this possible??

Thanks in advance!

[Simon Lloyd]

Wwill you always want the copied results of rows 6 & 7 to go in rows 8 & 9?

[Crüe]

Well... code I'm currently using copies row 6 and inserts new copy always in row 7. New copy always inserts in row 7 and previous copy drops to row 8 and so on.

[Simon Lloyd]

Well... code I'm currently using copies row 6 and inserts new copy always in row 7. New copy always inserts in row 7 and previous copy drops to row 8 and so on.

Really?, the code you displayed is hard coded for row 6!

So, let me get this right, you want to copy rows 6 & 7 and paste them in the next available blank row? or always in rows 8 & 9?

I'm having trouble understanding what it is you want really.

[Crüe]

It's hard to understand if you're foreigner :P But let's say I want them always in rows 8 & 9

[Simon Lloyd]

in that case the below should work

Please Login or Register  to view this content.

[Crüe]

Works like a charm! Thanks!