LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Loop till value changes Ruben Excel Discussion (Misc queries) 2 August 27th 08 09:07 AM
How can i Change Autofilter data from top till bottom in macro Vijay Kotian Excel Discussion (Misc queries) 0 September 5th 06 09:10 AM
row that needs to wait till the next page break befor copying wil4d Excel Discussion (Misc queries) 0 December 20th 05 02:36 PM
Force Macro to wait till Refreshall is done NCSU_madman Excel Programming 3 November 10th 04 04:39 PM
Macro to nsert value from table, then next value, till done Sheryl Lang Excel Programming 1 December 5th 03 10:33 PM


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"