Last week, you folks clued me onto a wonderful, free PDF creator. Often, I
want to create a three page PDF from 3 of the worksheets in my EXCEL
template and it doesn't seem that I can highlight only those three sheets
together and make it happen. However, if I save a copy of my excel file
with all the other sheets deleted, after paste specialing values into the
three output sheets, of course - not a big deal to do via a macro - then it
seems quite able to print all the three sheets remaining in the revised
EXCEL file as a single PDF. In other words, it seems able to print all the
sheets into a single PDF, or just one sheet, but nothing in between. Or am
I wrong?

Regardless, I just did such a macro and it worked. The only problem is
that, I add additional sheets to some files and even change the names of the
other sheets (not the three in question). So, I need a macro subroutine
that will say, if the sheet name is anything other than Joe, jack, and
Harry, delete it. Can anyone help me with this?

Thanks much!
Dean