Thread: Setting page layout and print set up in code for a new worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NDBC NDBC is offline
external usenet poster
  
Posts: 204
Default Setting page layout and print set up in code for a new worksheet
I have just created a new worksheet with the data the way I want it. Now I
would like to set the page layout for printing to landscape and set it so it
scales to print 1 page wide by 10 pages long. Can this be done in code.

In my code the sheet is called wbNew.Sheets("results")

Thanks
Reply With QuoteReply With Quote