ActiveSheet.PrintOut

Posted by jim on January 29, 2002 9:37 AM

Hi,

I found in help "ActiveSheet.PrintOut" what
i would like to do is to be able to define it to
a particular page. I have 2 pages on the sheet and
would like to only print the 2nd page.

TIA

Jim

Posted by Loon on January 29, 2002 10:26 AM

This macro will do the trick

Posted by jim on January 29, 2002 10:45 AM

Posted by Ian Mac on January 30, 2002 4:32 AM

Select the area you want and goto File/Print_Area/Set Print Area and use your macro

ActiveSheet.PrintOut

You shouldn't need this but...
I've just recorded these actions and got this

Range("A9:Y25").Select
ActiveSheet.PageSetup.PrintArea= "$A$9:$Y$25"

Change the A9:Y25 to the area you want
then add the PrintOut bit

hope his helps

Ian Mac