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

- - Latest reply: TrowaD
Posts
2562
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 14, 2019
- Oct 17, 2019 at 12:19 PM
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?
See more 

1 reply

Posts
2562
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 14, 2019
370
0
Thank you
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
Respond to TrowaD