| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set print area using macros
Can anyone help...this is what i need...a button with a macro attached so
that it auto-sets the print area to include only the cells with values? IE - if there were only 10 rows of data with input, then the print area would be set accordingly; if there were 200 rows of data , the print range would be set accordingly; etc -- SheriQ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock a print area | Excel Discussion (Misc queries) | |||
| PivotTable - Where have the units/records gone? | Excel Worksheet Functions | |||
| Print Area Shifts | Excel Discussion (Misc queries) | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
Linear Mode
