how to add one same word on every 10th line

[elavenil]

hi,
i have excel with 50000 lines.i have to insert this word
"###break###" on every 10 th line.how to do this?
i tried macro but cannot able to do.i need help.advance thanks for your
help.

 

[Guest]

here's a macro you can use. Just modify it to suit your needs.

Sub test()
Dim i As Long
For i = 1 To 5000
Sheets(1).Range("A1").Offset((i - 1) * 10, 0) = "###break###"
Next i
End Sub

cheers,

Scott