200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I am working with one of your site's established macros " Delete Entire Rows Based on Predefined Criteria (Text). It works very well but after I entered 55 texts in the Search part it would not let me add any more. Can you provide a modified macro code to allow the macro to search for more texts, e.g. an unlimited number if possible? I have attached a sample file containing around 400 rows of text. Five of them are highlighted as ones which the macro will delete.
Thanks,
Alan
Without seeing the macro that you used, after you edited it, I can only guess what might have gone wrong. However, without seeing it, I can give you a simple(ish) solution that might work.
Create another macro that calls the original macro multiple times.
This requires that you add a variable to the original macro like this:
Sub Delete_Based_on_Criteria(searchTermsVar)Edit this line of the original macro:
SearchItems = Split("INPUT TEXT HERE, INPUT TEXT HERE", ",")Change it to:
SearchItems = searchTermsVarNew macro:
Sub call_delete_row_macro()
SearchItems = Split("INPUT TEXT HERE, INPUT TEXT HERE", ",")
Call Delete_Based_on_Criteria(SearchItems)
'Repeat as needed
SearchItems = Split("INPUT TEXT HERE, INPUT TEXT HERE", ",")
Call Delete_Based_on_Criteria(SearchItems)
End Sub