| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set Print Area
Try this
LastRow = Range("$L$1").Value Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$K$" & _ LastRow Regards Klaus -----Original 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| print area across the freeze panes area | Excel Worksheet Functions | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
Hybrid Mode
