Hello All,

Very new to VBA, but am working on a project that involves several thousand lines of Excel Data. This data has to be input into another ancient system for which the input capability is 18 lines. They require that when we supply the data, it is in groups of 18 to expedite their input.

I'm trying to find a very simple formula that starts at the first row of data and will input a blank row after every 18 rows. Any assistance will be appreciated! Many of the VBA codes I have tried to use insert to the very bottom row, almost in a do-loop, regardless of if it has data or not.

The code I'm currently trying to use is

Sub insert()
m = Range("a1").CurrentRegion.Rows.Count
For i = m To 2 Step -18
Cells(i, 1).EntireRow.insert
Next
End Sub

but it isn't counting in increments of 18 as there are small groups (2 and 3 rows) of data on both the front and tail end of the data set.

Thanks!