Print From user form.

Hi all,

am using this code to print from an user form. But each time i print 2 copies it came out 3 copies. Can any1 help to identify what is the problem

Thanks
leo

Please Login or Register  to view this content.

You are looping from 1 to the number of pages. So the first time through the loop, you print 1 copy. Then p becomes 2, and so the next time through the loop you print 2 copies. Total of 3 copies. You don't need a loop.

To fix this, remove the red lines of code.

Please Login or Register  to view this content.