Using macro for page break

Sara · Jan 13, 2005

How can we use a macro to insert page breaks every 25th line? Please help.

Earl Kiosterud · Jan 13, 2005

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.

Sara · Jan 13, 2005

Thanks Earl!

Earl Kiosterud said:
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.