macro to loop till end of page
 

Hello ~ i'm trying to creat a macro that searches on a word, then inserts a
pagebreak. But i don't know how to make it loop till the end of the
worksheet. I won't know the last row - being this worksheet with continually
grow larger. Thanks.

macro to loop till end of page
 

Look at the help example for the FindNext method.

--
Regards,
Tom Ogilvy


"Nadiya" wrote in message
...
Hello ~ i'm trying to creat a macro that searches on a word, then inserts
a
pagebreak. But i don't know how to make it loop till the end of the
worksheet. I won't know the last row - being this worksheet with
continually
grow larger. Thanks.