macro that loops till end of worksheet

[Guest]

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

 

[Frank Kabel]

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

 

[Tom Ogilvy]

See answer to your first posting of this question.