Report Printing Macro Help

I am very new to Macros and VBA and this is my first post on the forum so please forgive me if it is in the wrong place.

I am trying to use a macro in excel 2010 to save over 300 individual quarterly reports as independently named PDFs for our clients. This macro should select a name from a data validation list in cell G1, which populates the reports, and then save an array of sheets as a pdf. I would like for it to name the pdf file using the value in G1.


This is the code I am using to print and save the PDF files.

Please Login or Register  to view this content.

I believe the the save function works but what I cannot figure out is how to get the macro to cycle through the data validation list giving enough time to populate each client's quarterly report before printing it. Each time I try it only prints one and never changes the value in cell G1 I tried to add some time delays but they did not help at all.

Thanks for any help you can give me.

My entire code albeit wrong:

Please Login or Register  to view this content.

Try this:

Please Login or Register  to view this content.

NOTE: You should edit your post #1 and add code tags, like I've shown here in this post. (instructions in my signature)

Read through the Forum Rules (link above)... lots of useful tips.