Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting rows automatically?
hi,
Does any one know how to insert X number of rows after each rows? ie, want to insert 5 rows after row 1,another 10 rows after row 2...? eg. row 1: holiday inn row2: hyatt row3: ritz and i want to insert 5 rows after row 1, another 5 after row 2 etc, so that i can write down places names that have those hotels in the new rows: row1:holiday inn hk uk us japan norway row6:hyatt uk hawaii .... etc. How can you do it? Please help! Elaine |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting rows automatically?
this should put a smile on your face
Sub insert5rows() For i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -1 Rows(i).Resize(5).Insert Next End Sub -- Don Guillett SalesAid Software wrote in message ups.com... hi, Does any one know how to insert X number of rows after each rows? ie, want to insert 5 rows after row 1,another 10 rows after row 2...? eg. row 1: holiday inn row2: hyatt row3: ritz and i want to insert 5 rows after row 1, another 5 after row 2 etc, so that i can write down places names that have those hotels in the new rows: row1:holiday inn hk uk us japan norway row6:hyatt uk hawaii ... etc. How can you do it? Please help! Elaine |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
inserting rows automatically?
oh my god!!!
That did put a smile on my face!!! Thank you so much! Elaine Don Guillett wrote: this should put a smile on your face Sub insert5rows() For i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -1 Rows(i).Resize(5).Insert Next End Sub -- Don Guillett SalesAid Software wrote in message ups.com... hi, Does any one know how to insert X number of rows after each rows? ie, want to insert 5 rows after row 1,another 10 rows after row 2...? eg. row 1: holiday inn row2: hyatt row3: ritz and i want to insert 5 rows after row 1, another 5 after row 2 etc, so that i can write down places names that have those hotels in the new rows: row1:holiday inn hk uk us japan norway row6:hyatt uk hawaii ... etc. How can you do it? Please help! Elaine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting alternate blank rows in Excel | Excel Discussion (Misc queries) | |||
Automatically insert/delete rows to be x apart | Excel Discussion (Misc queries) | |||
Deleting Rows Automatically using a Text File List | Excel Discussion (Misc queries) | |||
Problems inserting rows | Excel Discussion (Misc queries) | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) |