P
Paperback Writer
Is there a way to set the print area so that it automatically adjusts down as
new lines are added?
new lines are added?
D
Dave Peterson
Excel is pretty smart. It should adjust when you add new rows.
In fact, you may find that excel doesn't react to rows that are deleted. You
can use some of the techniques at Debra Dalgleish's site to reset that last used
cell:
http://www.contextures.com/xlfaqApp.html#Unused
In fact, you may find that excel doesn't react to rows that are deleted. You
can use some of the techniques at Debra Dalgleish's site to reset that last used
cell:
http://www.contextures.com/xlfaqApp.html#Unused
D
Dave Peterson
ps. And this assumes that you haven't explicitly set the print range.
R
Ron Coderre
If Excel isn't choosing the correct print range automatically (possibly due
to outlying cells you don't want included, you might try something like this:
<Insert><Name><Define>
Names in workbook: Print_Area
If your print data begins in A1
1 and you want it to continue through the
last nonblank cell in Col_A...
Where there may be blanks within Col_A:
Refers to:
=OFFSET(Sheet3!$A$1:$D$1,,,MAX(MATCH(10^99,Sheet3!A:A),MATCH(REPT("z",255),Sheet3!$A:$A)))
If there will be no blanks in Col_A then:
Refers to: =OFFSET(Sheet3!$A$1:$D$1,,,COUNTA(Sheet3!$A:$A))
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
to outlying cells you don't want included, you might try something like this:
<Insert><Name><Define>
Names in workbook: Print_Area
If your print data begins in A1
1 and you want it to continue through thelast nonblank cell in Col_A...
Where there may be blanks within Col_A:
Refers to:
=OFFSET(Sheet3!$A$1:$D$1,,,MAX(MATCH(10^99,Sheet3!A:A),MATCH(REPT("z",255),Sheet3!$A:$A)))
If there will be no blanks in Col_A then:
Refers to: =OFFSET(Sheet3!$A$1:$D$1,,,COUNTA(Sheet3!$A:$A))
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro