Setting horizontal print area

[sven.lowry]

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?

 

[Jim Rech]

it automatically sets all the rows to be in the print area, but not the
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
|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?
|