| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert blank row every 10 rows
Worked perfectly. Thanks so much.
"Rick Rothstein" wrote: Your question is not entirely clear as to which row should be the first blank row... 11 or 12. Assuming 11, try this macro... Sub InsertRowsEveryTenthRow() Dim X As Long, FirstBlankRow As Long, Increment As Long, U As Range FirstBlankRow = 11 Increment = 10 For X = FirstBlankRow To ActiveSheet.UsedRange.Rows.Count Step Increment If U Is Nothing Then Set U = Rows(X) Else Set U = Union(U, Rows(X)) End If Next U.Insert End Sub -- Rick (MVP - Excel) "aileen" wrote in message ... Is it possible to insert a blank row every 10th row starting from row 11 and going until the last and variable row of data? . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert blank rows | Excel Discussion (Misc queries) | |||
| Text to Rows and then Insert Blank Rows | Excel Discussion (Misc queries) | |||
| How do i insert blank rows between data that is thousands of rows | Excel Discussion (Misc queries) | |||
| Insert Blank Rows | Excel Programming | |||
| How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
