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 ?

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

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

Thanks for that Gary. Has done the trick.