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
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?
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:
- FindAll This custom function returns Find and FindNext results as an array of va
- Ultimate custom night download - Download - Horror
- Custom resolution utility - Download - Customization
- Find function on mac - Guide
- Dino game custom character - Guide
- Vba check if value is in array - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 17, 2019 at 12:19 PM
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
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
