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