FindAll This custom function returns Find and FindNext results as an array of va [Closed]

Report
-
Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
-
Find All
This custom function returns Find and FindNext results as an array of values. It will find all the instances of a string (sText As String) and returns an array containing the line numbers.

Question: How could I modify the subject Macro to Find All instances of an email address in my table of contacts then delete all rows with those instances?

1 reply

Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
446
Hi Rodwell,

You forgot to post the custom function.

Or would you prefer a code that asks you for a string of text and then deletes all the rows containing that string of text? Are the email addresses in 1 column or all over your sheet?

Best regards,
Trowa