I may be wrong, but I believe the print area must be a single rectangular, i.e. just one area.
You can't eliminate a piece out of the middle of it. But you would certainly not want to set the
sheet to print all 65,536 rows and 256 columns.

Maybe you could put a rectangle over this area and change its fill to white before printing. If
that works, you could automate this with a macro.

On Mon, 18 Aug 2003 01:03:14 GMT, (Wild Bill) wrote:

I am trying to hide or "mask out" a section of a sheet from printing.
E.g. I want to prevent B5 through D10 from printing. I do *not* want to
do so permanently, so just building a print area with control-clicks is
no good (if that even works).

I'll use VBA to toggle it. The nuisance here is that the shape of the
rest that I DO want to print is odd, making me need to specify the print
area as something like
"A:A;B1:D4;B11:D65535;E:IV"
which, even if that works, is too hardcoded (e.g. what if I modify the
range to be masked?).

Well I did set up a range for the masked area but still don't know how
to hide it from printing.
Range properties considered:
.hidden: only works for full rows or columns
.visible: is not a property for ranges
.characters: This has promise. Maybe I can switch the color to white
during printing.

Changing column widths: Nope, affects cells above and below my
mask-range.

Am I missing the obvious solution?

In fact you can - using a comma (not a semicolon as I thought earlier)
in page setup.


Yes you can, but it prints each area on a separate piece of paper.

Regards,
Tom Ogilvy


"Wild Bill" wrote in message
...
I may be wrong, but I believe the print area must be a single
rectangular, i.e. just one area.
You can't eliminate a piece out of the middle of it.

In fact you can - using a comma (not a semicolon as I thought earlier)
in page setup.

Or control-click as I mentioned, from page setup and the navigation
icon.

But you would certainly not want to set the
sheet to print all 65,536 rows and 256 columns.

True.

Maybe you could put a rectangle over this area and change its fill to
white

Well that's my hokey leaning so far. I guess changing the fill beats my
best so far, using With myrange and .Characters.font.
Thanks.

Thanks for looking at this, great Tom. Now that I see that you've
looked at my original problem, I can sleep knowing that if my original
problem had an answer available, I'd now have heard it LOLOL!

Yes - multiple select areas (set to print area) do print that way.

On Mon, 18 Aug 2003 08:48:34 -0400, "Tom Ogilvy"
wrote:

In fact you can - using a comma (not a semicolon as I thought earlier)
in page setup.


Yes you can, but it prints each area on a separate piece of paper.

Regards,
Tom Ogilvy


"Wild Bill" wrote in message
...
I may be wrong, but I believe the print area must be a single
rectangular, i.e. just one area.
You can't eliminate a piece out of the middle of it.

In fact you can - using a comma (not a semicolon as I thought earlier)
in page setup.

Or control-click as I mentioned, from page setup and the navigation
icon.

Which isn't what you want, is it?

On Mon, 18 Aug 2003 13:38:38 GMT, (Wild Bill) wrote:

Yes - multiple select areas (set to print area) do print that way.