Getting Best Print Results

[realniceguy5000]

Hi,

I have a 1 page spreadsheet that I need to get the best look when printing. The Range is A1:E68 The issue is when I hide rows in this range it makes the spreadsheet smaller. So it doesn't fit the page correctly and the zoom could be larger to make it look better.

My Question is how to get the best zoom in the page setup?

I have successfully done this manually by looking at the pagebreakpreview and dragging the first line on the far left all the way to the right.

When I recoded a macro I get this:

Please Login or Register  to view this content.

Is there another way to get this results? With out having to change the view of the window. Or maybe another option?

Here is a test workbook with script inside.

Thanks for looking...
Mike

[snb]

Did you consider using:

Please Login or Register  to view this content.

[realniceguy5000]

No I didn't think about that option, I guess that may work...Thank You...

I was hoping to get away from

Please Login or Register  to view this content.

Which only works when I activate each sheet in the wb which I didn't want to do.


In order to use this snipit:

Please Login or Register  to view this content.

The script works I just thought there must be a better way...

Thanks, Mike