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?