Hello,
I'm using this macro-code to insert new rows into worksheet
Sub insertrow()
ActiveSheet.Unprotect
With Rows(6)
.Copy
.Insert 'the copy will be put in the newl;y created row
Range("D6").ClearContents
End With
Application.CutCopyMode = False
ActiveSheet.Protect
End Sub
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!
Bookmarks