Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting alternate blank rows in Excel KopRed Excel Discussion (Misc queries) 4 April 14th 08 10:32 PM
Automatically insert/delete rows to be x apart Mr_Flibble Excel Discussion (Misc queries) 5 February 17th 06 05:04 AM
Deleting Rows Automatically using a Text File List mirdonamy Excel Discussion (Misc queries) 9 January 12th 06 12:11 AM
Problems inserting rows KathleenK Excel Discussion (Misc queries) 1 August 18th 05 02:13 AM
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? Phil A. Excel Discussion (Misc queries) 1 April 19th 05 04:10 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"