Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 14th 04, 07:55 PM
grantm5
 
Posts: n/a
Default how do I insert multiple rows in excel after every row of data

I need to insert 23 rows after every row that is currently in my spreadsheet

  #2   Report Post  
Old December 14th 04, 08:09 PM
Bob Phillips
 
Posts: n/a
Default


For i = Cells(Rows.Count,"A").End(xlUp).Row To 1 Step -1
Cells(i+1,"A").Resize(23,1).Entirerow.Insert
Next

--

HTH

RP
(remove nothere from the email address if mailing direct)


"grantm5" wrote in message
...
I need to insert 23 rows after every row that is currently in my

spreadsheet




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
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 07:39 PM
insert multiple page Word document into Excel S.W. Excel Discussion (Misc queries) 2 December 7th 04 11:29 PM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 08:16 PM
insert data from one excel file into another Leonard Excel Discussion (Misc queries) 1 December 2nd 04 12:35 PM


All times are GMT +1. The time now is 02:56 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017