add row every two rows
 

how can i add row every two rows
for example

row 1 150
row 2 200
insert row
300
180
insert row

and so on

thanks for your help

add row every two rows
 

works down 1000 rows,- change if ness.

Sub addrow()
Dim t
Application.ScreenUpdating = False
For t = 3 To 1000 Step 3: Cells(t, 1).EntireRow.Insert: Next
Application.ScreenUpdating = True
End Sub


"andresg1975" skrev:

how can i add row every two rows
for example

row 1 150
row 2 200
insert row
300
180
insert row

and so on

thanks for your help