The preferred method is to use a defined name
Assuming you have a Print_Area modify it to use an OFFSET formula such as
=offset($a$1,0,0,counta($a:$a)-1,15)
Now, it will be self adjusting without action on your part
Look in the help index for OFFSET


Don Guillett
Microsoft MVP Excel
SalesAid Software

"nc" wrote in message
...
How can I set a print area using macros, up to the last filled row and
hard
code the number of columns ?