Thread: pagebreaks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default pagebreaks

Automatic pagebreaks only come into play if they are required. If you put
in a pagebreak a line 100 and line 200, but the sheet can only print 66
lines per page, then the automatic pagebreak is created. If you put in
pagebreaks at 60, 120, 180, 240, then the automatic pagebreaks will not
appear.

--
Regards,
Tom Ogilvy

"Yiannis H. Economides" wrote in message
...
Is there a way to disable (with VBA) the page breaks
and use only code inserted page breaks ?

Yiannis H. Economides