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.

[Bob Phillips]

For i = Cells(Rows.Count,"A").End(xlup).Row To 10 Step -1
If i Mod 10 = 0 Then
Rows(i).Insert
cells(i,"A").Value = "###break###"
End If
Next i

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"elavenil" <elavenil.2ckkqd_1155625503.7442@excelforum-nospam.com> wrote in
message news:elavenil.2ckkqd_1155625503.7442@excelforum-nospam.com...
>
> 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.
>
>
> --
> elavenil
> ------------------------------------------------------------------------
> elavenil's Profile:
http://www.excelforum.com/member.php...o&userid=37522
> View this thread: http://www.excelforum.com/showthread...hreadid=571670
>

[elavenil]

wooooooo thanks Bob Phillips