View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Allan Allan is offline
external usenet poster
 
Posts: 57
Default How do I ensure that all the data is on one page when printing in.

I have a worksheet that is comprised of tables.
I need to ensure thta tables do not overlap the end of the page. How do I do
this in a macro?

THe page length seems to be set by the paper size but I can't make
alterations stick! The pagebreak keeps interferring!

thanks in anticipation.

Allan Thompson