ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to insert a row at regular intervals of row (https://www.excelbanter.com/excel-programming/407336-how-insert-row-regular-intervals-row.html)

dsnema

how to insert a row at regular intervals of row
 
Hi, I need to insert a row after a regular intervals of 180 rows in a big
data file. How can I enter?

Gary''s Student

how to insert a row at regular intervals of row
 
Sub insert_them()
For i = 181 To 999 Step 180
Rows(i).Insert Shift:=xlDown
Next
End Sub

--
Gary''s Student - gsnu200772


All times are GMT +1. The time now is 01:08 PM.

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