Set Print Area
 

I would like to use the property Print Area. This property
requires two give two cells for the array: top-left corner
and the bottom-right one. The top-left corner is constant
at $A$1. The bottom right has a constant column "K" but
its row varies.

Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$K$?"

How could I specify the value for the row in the PrintArea
property taking into account that this value is a number
shown in cell $L$1

Can anyone provide me with the code?

Thank you very much,

Marc

Set Print Area
 

Marc

Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$K$" & Range("L1").Value

Regards

Trevor


"Mark" wrote in message
...
I would like to use the property Print Area. This property
requires two give two cells for the array: top-left corner
and the bottom-right one. The top-left corner is constant
at $A$1. The bottom right has a constant column "K" but
its row varies.

Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$K$?"

How could I specify the value for the row in the PrintArea
property taking into account that this value is a number
shown in cell $L$1

Can anyone provide me with the code?

Thank you very much,

Marc