Using macro for page break

[Guest]

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

 

[Earl Kiosterud]

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.

 

[Guest]

Thanks Earl!

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.