Print Area Resizing

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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.
 
Use a defined name for the printrange
insert>name>define>name 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
 
thanks Don, will try this
Don Guillett said:
Use a defined name for the printrange
insert>name>define>name 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
(e-mail address removed)
want
Click to expand...
 
Back
Top