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