Macro to pull from GAL based on excel values

Oh... yikes... :embarassed:

Change this line:

Code:
[COLOR=#333333]sEmails = sEmails & ","

To this:

Code:
[/COLOR][COLOR=#333333]sEmails = sEmails & Cl.Value & ","

I can't believe I missed adding the cell's value to the text string. Doh![/COLOR]
 
YESSS :rockon:

Thank you so much Ken for all the help and speedy replies! I really do appreciate you putting up with my noob questions!
Please also let me know if there is somewhere i can leave feedback/promote the forum :)
 
One more thing... remove all the lines from your code that start with Debug.Print. Those will slow the macro down at run time.

Re promotion, I appreciate that. Just tell your friends to check us out when they have issues. :)

Also, if you're interested in learning more about Excel/VBA, hang out and try to answer a few questions. You'll be blown away at how much you learn. ;)

Cheers!
 
Back
Top