Hi
for getting the lastrow see:
http://www.xldynamic.com/source/xld.LastValue.html#vba

--
Regards
Frank Kabel
Frankfurt, Germany

"Nadiya" schrieb im Newsbeitrag
...
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