Maybe add a check to see if e is blank: If Not .exists(e) And e <> vbNullString Then .Add e, Nothing End If
If Not .exists(e) And e <> vbNullString Then .Add e, Nothing End If
Click here for a guide on how to add code tags Click here for a guide on how to mark a thread as solved Click here for a guide on how to upload a file with your post Excel 365, Version 2408, Build 17928.20080
Forum Rules
Posting Permissions
Reply With Quote