Crew,
I have this code, it works good, but how do I set it to select printer "Adobe PDF on Ne02:" so I can print to PDF and the file name to equal the selection in B3 (validation list as specified in the code) in this directory "C:\Temp"?
I have around 20 options in the drop down (validation list) in B3. So the code, loops thru each of the selection and prints the sheet (which changes after each selection). However the code prints to the default printer. I want to PDF them and save them in directory I stated before with the selection in B3 as the file name.
Thanks,
Bookmarks