Excel Print Worksheets by Name

Question

I've got an Excel 2007 Spreadsheet and I'd like to write a VBA procedure to print particular worksheets by name. How do I do this?

For example, I'd like to print "FirstSheet","ThirdSheet", and "FourthSheet" but not "SecondSheet".

Answer 1

If you know the sheet name simply call the PrintOut function like this:

Sheets("Name").PrintOut

For small amounts of sheets it is quite more easy by this way!