View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] brian.west@fox.com is offline
external usenet poster
 
Posts: 2
Default setting print area to selected cells

Hi. Is there are way to set the print area based on the cells that are
currently selected/highlighted? So, this time I have the range A1:D27
highlighted and I want that to be the print area, but next time I want
B9:KE102 to be the print area. I've figured out how to have a macro
select the area I want, but don't know how to have a "flexible" print
area. thanks in advance