Printing ranges

  • Thread starter Thread starter Tamsyn
  • Start date Start date
T

Tamsyn

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
 
If you are printing everything on the sheet, can't you just use the "Fit to"
in page setup, and not worry about print ranges?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Print a worksheet to a page 4
Print Fit To Not Working 1
maximize printing surface 3
Print Macro 5
Printing question 3
Excel print area which only prints pages of worksheet which are active 0
Print preview/page set-up is printing 100's of blank pages 2

Back
Top