| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select print area
What code do you use to select the print area of the active sheet?
i.e. something like PrintArea.Select |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select print area
mcphc wrote:
What code do you use to select the print area of the active sheet? ..PageSetup.PrintArea = "A1:B2" -- HTH /Sune |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select print area
The print area is a range defined by the name "Print_Area". So if you record
a macro whilst selecting that from the Names combobox, you get : Application.Goto Reference:="Print_Area" or you can use Range("Print_Area").Select You should check for that name first or handle the error that will occur if the print area is not defined. NickHK "mcphc" wrote in message ... What code do you use to select the print area of the active sheet? i.e. something like PrintArea.Select |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select print area
NickHK wrote:
The print area is a range defined by the name "Print_Area". So if you record a macro whilst selecting that from the Names combobox, you get : Application.Goto Reference:="Print_Area" or you can use Range("Print_Area").Select {flashbulb-above-head} Oh, now I get the questions. mcphc: Please disregard my post. -- /Sune |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel automatically select print area on non-blank cells? | Excel Discussion (Misc queries) | |||
| How to end/up end/across to select print area? | Excel Discussion (Misc queries) | |||
| Create a print macro that would automatically select print area? | Excel Worksheet Functions | |||
| Select Cells in Print Area | Excel Programming | |||
| Macro to select the print area | Excel Programming | |||
Hybrid Mode
