Previous Topic Next Topic

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

Closed
RodwellSmith - Oct 11, 2019 at 08:54 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - 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?
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 17, 2019 at 12:19 PM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Sims 2!! Custom content pleasee helpp me!! :(
smiley cupcakee xx :] -
Levy -

25 responses
Excel function question
1234ah -
ac3mark -

3 responses