Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Area Resizing
Hi,
Is there a way of setting a variable print area that the area can grow or diminish depending on rows being added or deleted? There are a fixed number of columns so columns are no problem. I want to pop this in a macro within this worksheet as a before print macro so that it only prints what I want it to print. I hope I have explained the problem clearly. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Area Resizing
Use a defined name for the printrange
insertnamedefinename it something like myprintrange in the refers to box =offset($a$1,0,0,counta($a:$a),6) will print from a1:e? which automatically adjusts to the rows in col A now you can use the FILE menu to set that as your printrange or put in the before print event of the ThisWorkbook module -- Don Guillett SalesAid Software "Mike" wrote in message ... Hi, Is there a way of setting a variable print area that the area can grow or diminish depending on rows being added or deleted? There are a fixed number of columns so columns are no problem. I want to pop this in a macro within this worksheet as a before print macro so that it only prints what I want it to print. I hope I have explained the problem clearly. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Area Resizing
thanks Don, will try this
"Don Guillett" wrote in message ... Use a defined name for the printrange insertnamedefinename it something like myprintrange in the refers to box =offset($a$1,0,0,counta($a:$a),6) will print from a1:e? which automatically adjusts to the rows in col A now you can use the FILE menu to set that as your printrange or put in the before print event of the ThisWorkbook module -- Don Guillett SalesAid Software "Mike" wrote in message ... Hi, Is there a way of setting a variable print area that the area can grow or diminish depending on rows being added or deleted? There are a fixed number of columns so columns are no problem. I want to pop this in a macro within this worksheet as a before print macro so that it only prints what I want it to print. I hope I have explained the problem clearly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File, print area, clear area, is not working | New Users to Excel | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
Unwanted Plot Area Resizing | Charts and Charting in Excel | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |