ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I insert multiple rows in excel after every row of data (https://www.excelbanter.com/excel-discussion-misc-queries/1874-how-do-i-insert-multiple-rows-excel-after-every-row-data.html)

grantm5

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

Bob Phillips


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




All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com