Can I make my PDF look better?

[tonywatsonhelp]

Hi Everyone,

OK not come across this one before but heres what i need.

I have a sheet with 3 different Ranges

Range B2:F10
Range J7:T37
Range AA3:AT40

Now the problem im having is I want these ranges to be my Page sizes
but when i print i get everything shrunk to match the width of

Range J7:T37

So probably be we ignore how im doing it heres what I want

A macro to set the above ranges as Print area
but print each sheet to fit 1 page wide in landscape

So

B2:F10 goes all the way across the page and so does

J7:T37

any ideas???

Thanks

Tony​

​

<strike></strike>

​