Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |