| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
| insert multiple page Word document into Excel | Excel Discussion (Misc queries) | |||
| Select all data, multiple rows | Excel Discussion (Misc queries) | |||
| insert data from one excel file into another | Excel Discussion (Misc queries) | |||
Hybrid Mode
