KentKHI
Active Member
- Joined
- Oct 1, 2004
- Messages
- 492
I am using For Each code to go through a column of email addresses. I only want it to operate once per each email address. The problem is that there are repeats of the same email address in that column, so it will activate the code multiple times for the same email address. Is there a fix for this?
Here is the code snippet:
Thankyou
Here is the code snippet:
Code:
For Each Rng1 In ActiveWorkbook.Sheets("Email").Range("emails")
If Rng1.Value <> "" Then
Thankyou