Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sara
 
Posts: n/a
Default Using macro for page break

How can we use a macro to insert page breaks every 25th line? Please help.
--
Sara
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Sara,

If your row height is consistent, you may be able to get the same result by
raising the bottom margin. File - Print Preview. Turn on the Margins
button. Drag the bottom margin (the upper one at the bottom -- the other is
for the footer) up until it prints only 25 rows.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Sara" wrote in message
...
How can we use a macro to insert page breaks every 25th line? Please
help.
--
Sara



  #3   Report Post  
Sara
 
Posts: n/a
Default

Thanks Earl!

"Earl Kiosterud" wrote:

Sara,

If your row height is consistent, you may be able to get the same result by
raising the bottom margin. File - Print Preview. Turn on the Margins
button. Drag the bottom margin (the upper one at the bottom -- the other is
for the footer) up until it prints only 25 rows.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Sara" wrote in message
...
How can we use a macro to insert page breaks every 25th line? Please
help.
--
Sara




Reply
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
Record Macro Relative does not work? lbbss Excel Discussion (Misc queries) 3 December 13th 04 08:43 PM
Record Macro Relative does not work? lbbss Excel Discussion (Misc queries) 1 December 13th 04 07:55 PM
Unable ot Break link for Macro with no source nate_l Excel Discussion (Misc queries) 1 December 10th 04 12:42 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Macro help Jeff Garrett Excel Discussion (Misc queries) 11 December 1st 04 08:47 PM


All times are GMT +1. The time now is 05:45 PM.

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

About Us

"It's about Microsoft Excel"