Frank,

Brilliant sorted, many thanks.

Mark

"Frank Kabel" wrote:

Hi
if your range has a different aspect ration then your paper it can't
work.

You could always try to set the page size ('File - Pagesetup'9 to 1
sheet high and wide


--
Regards
Frank Kabel
Frankfurt, Germany


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.