View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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