I have a workbook with a lot of sheets in it how ever I have a selection of sheets names p1,p2,p3 right throught to p21. what i need is a macro that selects only those sheets and prints it.

I tried the record macro and when I run it I get Dr.watson Excel preformed illegal operation.

So need a quick and easy hand written macro.

Cheers