Gary:
Thank you for your suggestion. Given my limited skills with macros I am not
likely to make good use of your idea (given the repetitious nature of using
this feature on so many print areas), however, I can see how I could make use
of this in other instances.
Thanks again.
Stephen

"Gary Rowe" wrote:

You could also try using the camera tool. The camera tool takes a picture of
the range of cells and you can place it on another sheet for printing along
with pictures of the other ranges so that you can get as many on a print area
as will fit. The picture of the range of cells has the range in the formula
bar and can be edited. The camera tool needs to be added by tools, customize
and drag the camera button to a toolbar.
Gary

"Jay" wrote:

I have about 100 worksheets, each has an identical structure.
The area on each worksheet to be printed is small. ...
Can I print all worksheets at once and use fewer than 50 double sided
pages?

If you do this sort of thing a lot, "fineprint" might help:
http://www.fineprint.com/products/fineprint/index.html

Among its features is the ability to print four-up; that is, to print four
"pages" on one side of one sheet. Two-up and eight-up, too.

It isn't free, but it's worth the price if you use its features a lot.

(I'm not affiliated with fineprint except as a customer. It has been useful
to me.)