Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set print area with code
I wonder who could help me with this:
When the user clicks on a button I would like to visualise a preview of the current page, but before I need to define Set Print Area according to the coordinates given in four cell (the four corners of the print area). What is the code that will set the print area according to the information given in four cells? Thank you, marc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set print area with code
Hi
You only need 2 cells. The top left and bottom right of the print area. Something like this. ActiveSheet.PageSetup.PrintArea = "$C$10:$E$15" HTH Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
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 | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) |