Hi All, I am a vba newbie and have been given a task that far surpasses my ability. I have a data validation drop down list with 77 different selections I need for a monthly report. I found a code that prints out the worksheet as based on the current selected option in drop down cell A1 (Strategy) into an external folder. What i would like to do is add a loop through code that automatically prints all different selections to seperate pdfs into the same folder when i click a button. My current code is:

Please Login or Register  to view this content.
The code I have found on another forum for the loop through is as follows, but i keep getting a run time 1004 error on it (Application defined). Does anyone know why? 

Please Login or Register  to view this content.
Thanks for your help! :)