stuck on a simple problem =(

[danmen]

yup I've tried coding this and I'm having problems, any help would be grandly appreciated!!

What I'd like to do is that whenever I highlight a range of cells directly
below a target row, then when I launch the macro new rows are inserted
in the highlighted range and the target row is copied over to them

for example:

say I have a row of data on line 1, now I highlight cells A2:B5, I launch the macro and ...

- new rows 2 to 5 are created
- row 1 is copied into rows 2 to 5

note I could have equally chosen C2:I5 OR T2:Z5 to obtain the same results

once again any help would be appreciated!

 

[shg]

Try this:

Sub x()
    With Selection.Areas(1)
        If .Row > 1 Then
            .Rows(0).EntireRow.Copy
            .EntireRow.Insert
        End If
    End With
End Sub

 

[danmen]

thx shg!