Thread
:
setting print area to selected cells
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
setting print area to selected cells
Maybe you don't have to change the print area??
If you're selecting the range, you could use:
Selection.printout 'preview:=true
or without selecting:
with worksheets("somenamehere")
.range("a1:d27").printout
.range("b9:ke102").printout
end with
wrote:
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
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson