creating multiple PDFs by looping through number list-- help needed

[davidy1968]

The code below is part of a macro being used to create a list of numbers and then loop through those numbers one at a time, place the number into cell I1 which is linked to numerous other sheets. Each of those sheets has a formula in cell Z1 that sets to "Yes" or "No" depending on if the current number in the list is on that sheet. If it is set to Yes, the macro is supposed to select each of those "yes" sheets and then create a PDF file, and then loops to the next number in the list.
There are two problems I haven't figured how to get around yet. First, the first loop through works correctly, but each subsequent loop keeps adding sheets that should not be marked "Yes". Second, it is also selecting the sheet the macro is running from, which I do not want it do.
Any suggestions are greatly appreciated!

Please Login or Register  to view this content.

EDIT: Fixed the first issue by selecting another sheet at the end of the main loop. Now just need to keep it from adding the activesheet to the PDF files.

[LJMetzger]

Hi and Welcome to ExcelForum,

Sorry for the late response.

Try adding the code in red:

Please Login or Register  to view this content.

Lewis