Check "sheet" under "page setup".
If you have any "columns to repeat", delete them. You do not need them if
wanting to print one page wide. I believe Excel reserves room for those
columns, thereby not allowing your print to utilize the full page. Deleting
them frees up room on the sheet for the type to now fill the full width of
the page.

"Mark" wrote:

I am using Excel 97.

Is there a way to programmatically ensure that the page setup uses the full
page of an A4 sheet.

I have set the print area to D3:S62 but despite altering the margins cannot
get the whole sheet used.

Any suggestions/solutions would be greatly apprecaited.


--
Mark A Whitehead