Can I set an automatic page breaks to break every 40 lines?
 

In Excel 2000, can I automatically set page breaks to every 40 lines instead
of the default 52 lines?

Can I set an automatic page breaks to break every 40 lines?
 

Hi Kennbu

With code you can do this
http://www.rondebruin.nl/print.htm#Breaks

--
Regards Ron De Bruin
http://www.rondebruin.nl



"Kennbu" wrote in message ...
In Excel 2000, can I automatically set page breaks to every 40 lines instead
of the default 52 lines?