Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Print selected sheets

Posted by Eugene Robinson on December 24, 2001 6:12 AM

On a first printout I use "ActiveWindow.SelectedSheets.PrintOut Copies:=1". On a second printout I always add Sheet 1 to the selection. What should I add to this instruction to reflect this ?

Re: Print selected sheets

Posted by Gary Bailey on December 24, 2001 9:16 AM

If you don't mind selecting Sheet1 then

Sheets("Sheet1").Select False

The False tells VBA to extend the selection, not replace it. So you should end up with what you had selected before plus Sheet1 selected not just Sheet1.

Gary

Re: Print selected sheets

Posted by Eugene Robinson on December 24, 2001 12:03 PM

Thanks for that Gary. Has done the trick.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.