Insert blank row after every nth row in Excel

The video offers a short tutorial on how to insert a blank row after every nth row in Excel.

[alpada]

Run-time error '1004'
Application-defined or object-defined error

[alpada]

Hi! i am getting this error - lr = Range("A" & Rows.Count).End(x1Up).Row

help me please... TIA

[j.j.aspirants]

Thanks Man,

it worked, My data was around 15000 numbers and I wanted to add each row after every 100 and It helped me very well

[jvmloveradors]

What if I dont have a developer? How to do this?

[findingpeace]

Want to insert the specific no of rows with some heading at first column at every nth row

[pratikshelar]

Bro this trick not working in libre office

[maylaitan]

it doesn't work, says the sub of the function is not defined

[danielstorm]

Copied it exactly and it didn't work, Syntax Error.

[applecake]

i dont have a developer how do I get it

[soongchi]

it damm bloody well works. thanks Prashant! ur a saviour