VBA Batch Print Error

I am trying to run a VBA code that batch prints workout cards for each name in a drop down list. I have had some level of success, where a print button embedded in the worksheet "GPP" will work the assigned VBA code to PrintAllCards (located in module 2). Unfortunately, the code is only printing the first name from the drop down list, and is printing copies of the first card multiple times. I have 3 sample names, and am expecting 1 print out of the specific cards for each of the three names (Sample 1, Sample 2, and Sample 3) and instead am getting the card for Sample 1 printed out 3 times.

I modified the VBA code from a gradebook template I found through office help, so it is very likely that I have just missed something in the coding.

Here is what I have currently:

Please Login or Register  to view this content.

Thank you for any help!

Try it like this - I have changed the code to loop through your list of athlete names on Settings - and have made that range dynamic so that you can add or delete names easily - just don't leave any blank spaces in your list of names.

Here is the code I use:

Please Login or Register  to view this content.

Try this macro, assigning it to a button on each sheet - it will only print cards based on the current sheet. If you decide to choose which athletes to print cards for, the macro will ask about each one.

Please Login or Register  to view this content.

You could also modify your Settings sheet to include a column next to the athletes name column, to show whether they should be printed or not - with this code, any entry in column B next to the name will cause the card to print for that athlete.

Please Login or Register  to view this content.

Anything for a soccer coach! My daughter was a Division III player, and I was a long-time youth coach and am still a much-abused referee