Split records or rows for every 100 rows -- require help

[mithelesh]

Hi all ,

Good Day!!!

Please suggest how to put a break for every 100 lines of records in excel.

No new sheets must be created. I have attached an excel sheet.

Regards
Mithelesh.S

 

[azumi]

Perhaps something like this? Cheers

 

[sudipto3003]

dear azumi,

can you please explain how you have done it?

 

[mithelesh]

Hi all

Goodday !!!

Please check the sheet , "To put a break for every 500th row or Nth row".

Code:

Sub InsertRowsMod9()
Dim r As Long
r = 501
Do Until Len(Cells(r, 1)) = 0
Rows(r).insert Shift:=xlDown
r = r + 501
Loop
End Sub

Regards
Mithelesh.S