Print range as Black/white + fit 1 page

[HereComesTheBoom]

I have B4:F91, which breaks pages(row-wise) and has color.

I wanna make a button to directly print it in black/white, and fit it to one page - can't seem to nail it - ironically i've made dozens upon dozens of these buttons in the past.

Has to be ActiveSheet, because I'm re-using the button in diff sheets

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M



P.S. Slightly better version

Please Login or Register  to view this content.

[Logit]

Please Login or Register  to view this content.

[HereComesTheBoom]

They both squizh it up and to the left, it,s because the columns fit fine, but rows are to long in the original.

both examples make it fill a quarter of the page.

[Greg M]

Hi again,

When you say:

both examples make it fill a quarter of the page

do you mean that it fills a quarter of the page width?


The aspect ratio of the printed range remains the same when the output is printed on (in this case) a single sheet, so if you "squish" the vertical dimension, the horizontal dimension will be "squished" proportionally also.

Regards,

Greg M

[HereComesTheBoom]

Yes.

Well - Can't I not change the width, but squish the length in to one page?

[Greg M]

Not as far as I know - sorry

[HereComesTheBoom]

I'm just confused, because.

Last year, I used the (almost) same WB, and in that, there is this

Please Login or Register  to view this content.

Which works fine... But not in this WB - could it be the page setup? It's the only part of the WB that ever needs printing