Thread: Printing ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tamsyn Tamsyn is offline
external usenet poster
 
Posts: 2
Default Printing ranges

Hi All
I've been asked for help to print out a large work sheet, it needs to be on
one page, there is data being added to the worksheet so setting a print
range will not work as the range changes. I would like to create a macro
that selects all the data on the sheet and then prints out on 1 page wide by
1 page tall. Is this possible.
many thanks