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
|
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