Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting 10 Rows
I have a list of data in two columns. I would like to
insert ten rows between each row of data (except the first row of course). Column A Column B 12.5 45 <ten rows 23 34 <ten rows 90 43 Any suggestions? TIA, Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting 10 Rows
Todd,
Sub Insert10Rows() Dim myRow As Long For myRow = Range("A65536").End(xlUp).Row To 2 Step -1 Cells(myRow, 1).Resize(10, 1).EntireRow.Insert Next myRow End Sub HTH, Bernie MS Excel MVP "Todd" wrote in message ... I have a list of data in two columns. I would like to insert ten rows between each row of data (except the first row of course). Column A Column B 12.5 45 <ten rows 23 34 <ten rows 90 43 Any suggestions? TIA, Todd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting rows inbetween rows of data ? | Excel Discussion (Misc queries) | |||
Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
Inserting Rows | Excel Discussion (Misc queries) | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
inserting rows | Excel Discussion (Misc queries) |