Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print area composed by more range
Hi all,
I know how to set a print area composed by two (or more) areas; i.e. I select range A1:B2 and then (with CTRL pressed) select A10:B12, so my print area is composed by two range. How can I do this with a macro? Thanks in advance JFM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print area composed by more range
I always try to learn the macro and see what code excel produces. this
solves many of these type problems. "Andrea" wrote: Hi all, I know how to set a print area composed by two (or more) areas; i.e. I select range A1:B2 and then (with CTRL pressed) select A10:B12, so my print area is composed by two range. How can I do this with a macro? Thanks in advance JFM |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print area composed by more range
Activesheet.PageSetup.PrintArea = "$A$1:$B$2,$A$10:$B$12" "Andrea" wrote: Hi all, I know how to set a print area composed by two (or more) areas; i.e. I select range A1:B2 and then (with CTRL pressed) select A10:B12, so my print area is composed by two range. How can I do this with a macro? Thanks in advance JFM |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print area composed by more range
I think Joel is trying to tell you that you can get this code by turning on
the macro recorder (tools=Macro=Record a new macro) then performing the action manually. Then turn off the macro recorder and look at the code recorded. In this case: Sub Macro1() Range("A1:D15,F19:J31").Select ActiveSheet.PageSetup.PrintArea = "$A$1:$D$15,$F$19:$J$31" End Sub -- Regards, Tom Ogilvy "Andrea" wrote: Hi all, I know how to set a print area composed by two (or more) areas; i.e. I select range A1:B2 and then (with CTRL pressed) select A10:B12, so my print area is composed by two range. How can I do this with a macro? Thanks in advance JFM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Area as dynamic range? | Excel Worksheet Functions | |||
Print area composed by more ranges | Excel Discussion (Misc queries) | |||
How to find Used Range and Print Area? | Excel Programming | |||
Print area/range | Excel Discussion (Misc queries) | |||
Selecting a range composed of current region + 2 rows | Excel Programming |