View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default setting complex print area

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.