Setting a Print range for 1 range within multiple ranges

[DKsmash2014]

Hello,

I have the following code - My question is how can I set the "Marketing & Sales Dept BGT.PDF" range to fit to 1 page and have the only one to do that? It's the only one where there are 3 rows that roll over - the others fit just fine.

Thank you!

Please Login or Register  to view this content.

[spitfireblue]

At the start of your code add this in:

Please Login or Register  to view this content.