print page X

[rjplante]

Here is an easy one.

I have a document that is two pages long and I want to know how to specify in the print macro to print just page 1 or just page 2.

Thanks,

Robert

 

[VoG]

Try like this

ActiveSheet.PrintOut from:=2, to:=2

 

[rjplante]

Thanks, it works great! I as using PrintOut (2,2,1) Which when I did that the VBA editor would pop up with what each section was asking for after I entered another comma. When I got done it would ask for an = sign. I just didn't know the formatting of the information.

 

[VoG]

Write that line of code in the VBE, click in Printout and press F1. It will give you all the options.