How can I set a print area using macros, up to the last filled row and hard
code the number of columns ?

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 ?

Thanks. One problem with the name method is that I have to define a name
plus code for each print button on the worksheet. If I use your formula
below, Excel adds the sheet name. I cannot use active sheet in the name.

The second is that I am using a macro that deletes the row a1, before
printing.


"Don Guillett" wrote:

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 ?

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nc" wrote in message
...
Thanks. One problem with the name method is that I have to define a name
plus code for each print button on the worksheet. If I use your formula
below, Excel adds the sheet name. I cannot use active sheet in the name.

The second is that I am using a macro that deletes the row a1, before
printing.


"Don Guillett" wrote:

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 ?

Thanks. I have to figured out how to code using active sheet method.

"Don Guillett" wrote:

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nc" wrote in message
...
Thanks. One problem with the name method is that I have to define a name
plus code for each print button on the worksheet. If I use your formula
below, Excel adds the sheet name. I cannot use active sheet in the name.

The second is that I am using a macro that deletes the row a1, before
printing.


"Don Guillett" wrote:

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 ?