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?

"Tamsyn" wrote:

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