Print Area

  • Thread starter Thread starter SMILE
  • Start date Start date
S

SMILE

Hello
I hope someone will help me to solve my problem.
I have the data from column A to G (from H.. everything is blank) and
keep adding data below it. Is there any way I can run a macro to selec
the print area by finding the last row? Eg: if I have data in 16 row
and when I run the macro it should select the range A1-G16 and set th
print area. Row 17 will have no data in it.
Hope it is clear.
Thanks in Advance
Regds
Tom
 
Hi

Just set your print area to columns A:G - the whole column. This will print
as much as you've got in the column without having to alter the area every
time.
 
I would probably use a defined name for the range.
insert>name>define>name it myprintrng>in the refers to box type
=offset($a$1,0,0,counta($a$a),7)
If a is not the longest column, use a different column or post back
 
Back
Top