Looking for an efficient way to print many sheets using VBA

[cr731]

I have a workbook with about 80 sheets, and I want to have a button to automatically print about 75 of those sheets. Is there an efficient way I can do something like this? I've searched around but have only found methods that require you to identify each sheet you want to print. With this many sheets that seems very inefficient... is there some code that will print sheets 1 through 50 and then 55 through 80?

As an unrelated question, is there any way I can re-order my sheets in the VBA project window? For some reason it isn't ordering them in the number of the sheets, for example I see something like this:

Sheet1 (Input)
Sheet10 (Sales)
Sheet11 (Costs)
Sheet2 (Lists)
....

Can I make it so it displays as

Sheet1 (Input)
Sheet2 (Lists)
....
Sheet10 (Sales)
Sheet11 (Costs)


Thanks in advance.

 

[cjcobra]

record a macro that selects the sheets you want to print, then print them. you'll only have to do it once, then you're done.