View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Setting printarea through range object

Setting a multirange printarea will result in multiple print jobs. Since
you are hiding the rows you don't want to print, you should set the print
area to one contiguous range and hide the rows you don't want printed --
unless you want multiple print jobs.

--
Regards,
Tom Ogilvy

"Berend Botje " wrote in
message ...
First of all, thanks for reacting.

Can I do the range thing with R1C1 coordinates? I can't get it to work
properly with multiple range selections. For example I want to select
columns 1 through AK of rows 1 through 200 and 250 through 400. How can
I do this?


---
Message posted from http://www.ExcelForum.com/