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

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.

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.

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