Dose selecting all your areas and then using Print - Selection work? If so
just record a macro using this method.
--
n00b lookn for a handout :)


"SteveDB1" wrote:

Hi all.
I have to ask a question...
I can only hope there is an answer different from what I've found.
Is there anyway to set up a worksheet for multiple print areas?
I want to pick various areas on the worksheet that will allow me to print
only the specified areas, and not the entire range of the X, and Y
coordinates that I have work on.
And yes, I am aware that I can just move the print area around to print each
region; as well as placing all of the data groupings on different worksheets.
E.g.,
I have work in regions
A1:K1000
Y1:BP47
A1050:W2000
As you can see, I'd have a huge region of wasted paper/space if I had to
print out all of the blank space from Y48 through BP 2000.
Thank you.