Wow. Even simpler than I thought! And you're more than welcome.
--
n00b lookn for a handout :)


"SteveDB1" wrote:

Well, it appears that Excel does allow for this.
After I read your post, I went into the "Page Setup" and entered three
distinct print areas, separated by a comma. Don't use a semicolon as it will
interpret that as an actual equation which it does not like.
The screen shuddered a bit, took a moment to think about it, and viola.
I had 3 distinct print areas.
totally editable one's to boot.
I'd tried this once a long time ago under 2000, and could not get it to work
the way I'd wanted.
So, thank you for your time, and getting me to think a little further
outside my mental boundaries.



"Arnie" wrote:

Sorry, I didn't explain that very well. First, clear the print area, then
select your regions (hold down Ctrl and highlight the 3 regions), the go to
Print and check Selection.
This is the code that resulted from my trial run:

Sub Print_region()
'
' Print_region Macro
' Macro recorded 9/6/2007 by a2holder
'

'
Range("A1:K1000,Y1:BP47,A1050:W2000").Select
Selection.PrintOut Copies:=1, Collate:=True
Range("A1").Select
End Sub
--
n00b lookn for a handout :)


"SteveDB1" wrote:

Hi Arnie,
No it doesn't.
The way I've found that it works is there is only a single print area
allowed per worksheet. Hence my post.
In this case, I'd like 3 print areas.
Perhaps I'm thinking too much Autodesk here, but if they can do it, why
can't Excel.
I.e., they allow an innumerable amount of areas to be printed.
They call their's viewports.
Granted, all one is doing is overlaying a viewport over a different location
of a single drawing. But the point is that it allows the user to have
multiple print areas.
Which brings up the thought that with AutoCAD there is a workspace, and then
there are print out spaces.
I.e., Paperspace, and Model space. Paperspace allows the user create a
completely unique print out. Modelspace allows the user to print, and create
a print out, but doesn't allow for varying scales within a single sheet.
Viewports, and paperspace does.

"Arnie" wrote:

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.