Print Area

[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

 

[Guest]

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.

 

[Don Guillett]

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