how to add one same word on every 10th line

E

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.
 
S

Scott

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
 
Top