LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 151
Default For each c in myRng insert 6 rows

Hi team

As the title suggests. I have days spanning from row 2 through to 270.

Rather than manually inserting 6 rows for each date, I was hoping someone could assist with something a tad quicker please.

Essentially something loke:

For each c in myRng
 
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
Loop for myRng for next set of 9 rows L. Howard Excel Programming 10 June 16th 15 04:12 PM
insert rows and copying cells in column b,c, and d into new rows gbpg Excel Programming 0 December 31st 09 12:34 AM
Insert rows: Formats & formulas extended to additonal rows Twishlist Excel Worksheet Functions 0 October 22nd 07 04:23 AM
Insert page breaks every 50 rows but do not include hidden rows Martin[_21_] Excel Programming 5 March 12th 07 05:10 PM
range("myrng"), names("myrng").RefersToRange?? active_x[_8_] Excel Programming 2 November 8th 03 01:39 PM


All times are GMT +1. The time now is 10:25 PM.

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"