reduce userform printing size

[scouse13]

hi guys, managed to get hold of some code to be able to print a userform from a command button in landscape, the only problem is it prints over 4 pages, any idea's on what i could add to reduce it to 1 a4 size would be appreciated - code below

Please Login or Register  to view this content.

scouse13

[Logit]

.
Try this :

Please Login or Register  to view this content.