Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Using macro for page break
How can we use a macro to insert page breaks every 25th line? Please help.
-- Sara |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Unable ot Break link for Macro with no source | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro help | Excel Discussion (Misc queries) |