Hello,

I have a macro that allows a user to navigate to a text file and import it
into an excel sheet, put in some summary data in rows 1 to 14, then format
the imported list, then add some summary data below the list.

The list always starts in cell A15, but the number of rows and columns
varies. I need to be able to:
-set the print area.
-remove the page break that puts the last one or two columns in the list
onto another page.

Any assistance greatly appreciated.
--
Thanks,
MarkN