See answer to your first posting of this question.

--
Regards,
Tom Ogilvy

"Nadiya" wrote in message
...
Hello,
I'm trying to create a macro that based on a search, inserts a pagebreak.
It
need to do this till end of worksheet - of which i won't know, being this
worksheet will continually grow. Any suggestions - thanks