Select print area
 

What code do you use to select the print area of the active sheet?

i.e. something like

PrintArea.Select

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

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

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