Re: Setting horizontal print area

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
<sven.lowry@xxxxxxxxx> wrote in message
news:1164822530.711020.188150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|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?
|


.

Quantcast