The paper selection offered by Excel is taken from the printer driver spec.
Have you tried with Excel set to 8 1/2 by 11 paper and wide margins?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"GregB" wrote in message
...
What would be the best way going about this?

How would I write a macro to do this?