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 :)


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=383483