Hi John,

What I want to do is print out a range but the current values within same
are quite small when printed, I don't want to permanently increase the size
as it also is an input screen for users and is the correct size the way it
currently is


The best way around this is to create an additional print sheet with formulas
pointing to the input sheet. Now you can make this print sheet as pretty or
ugly as you like, without affecting the layout and appearance of your input
sheet.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com