insert 3 blank rows after every 2 rows
how do i insert 3 blank rows after every 2 rows of data?
|
insert 3 blank rows after every 2 rows
Hi,
Right click your sheet tab, view code and paste this in. Change the 9 to the row wher you want insertion to start. Sub InsertRows() For i = 9 To 2 Step -2 Rows(i & ":" & i + 2).Insert Shift:=xlDown Next End Sub Mike "Nikhil" wrote: how do i insert 3 blank rows after every 2 rows of data? |
All times are GMT +1. The time now is 08:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com