Excel Ranges - Print to PDF

I have a multiple worksheet Excel document. I want to select multiple ranges from multiple worksheets and print to a PDF document. I want the macro to print all the ranges to one PDF file. Each range should be on its own page in the PDF file. I have tried using the plugins for Acrobat 4.0, but there is just no help that I have been able to find defining what each of the properties and options in the acrobat library does. Can you help me? If I can get a macro that will print one range and you can explain to me how to merge the subsequent ranges into the pdf file, that would be GREAT! I can easily select each range aftre the first range is ent to PDF and I know how to merge the subsequent rangers. Any help appreciated!