I have a number of spreadsheets with varying column and row counts.
When I switch to pagebreak view in Excel, it automatically sets all the
rows to be in the print area, but not the columns.

Using VBA, how can I set the print area to cover the last column with
data in it?

it automatically sets all the rows to be in the print area, but not the
columns.

That's not really true. Excel includes the entire used range in the print
area, unless you have set a specific print area already. Use File, Print
Area, Clear Print Area to see all columns (and rows)included.


--
Jim
wrote in message
oups.com...
|I have a number of spreadsheets with varying column and row counts.
| When I switch to pagebreak view in Excel, it automatically sets all the
| rows to be in the print area, but not the columns.
|
| Using VBA, how can I set the print area to cover the last column with
| data in it?
|