Delete multiple rows in large dataset via AutoFilter?

[mrbusto71]

Hey folks! I have an odd issue where I need to exclude emails from a dataset I'm copying/pasting.

Here's my code so far:

Please Login or Register  to view this content.

As you can see, the code here is pretty lengthy, but it works. My question is simply whether or not there's a way to accomplish the same thing in less code?

I basically just need to delete any rows that have multiple pre-defined email address, i.e. delete any rows where the user email is @hotmail, @gmail, @icloud, etc.

It works as is, so if not then it's not an issue, but it would be stellar to be able to add or remove email addresses to this in the future without having to copy/paste an entire section of code again.

Thanks for any and all comments/tips in advance!

[sktneer]

You may try something like this...

List all your email domains in the following line in the code without * wildcard.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[sintek]

I basically just need to delete any rows that have multiple pre-defined email address, i.e. delete any rows where the user email is @hotmail, @gmail, @icloud, etc.

Another option perhaps...

Please Login or Register  to view this content.

[Marc L]

Hi !

My question is simply whether or not there's a way to accomplish the same thing in less code?

Yes via a child way like some samples in threads : a helper column with a formula which returns TRUE for rows to delete,
a sort on this column then clear the group of rows at once ! And clear the helper column …