I have names in in Col F that I would like to delete containing
Queens
East
North
Port
William
However, when running my code, the rows containing this text is not deleted
It would be appreciated if someone could assist me
Please Login or Register to view this content.
When you say "containing" do you mean the word in question could be anywhere in the string?
i.e. should both "Queens of the Stone Age" and "Stone Age Queens" get deleted or just the first one because "Queens" is at the start of the string?
If the former then changing instances of "= 1" in your IF statement to "> 0" should do the trick.
BSB
try >0
Please Login or Register to view this content.
Another approach if you have lots of strings that you need to check and act on would be to create a list of the strings and use a helper column in your data with a MATCH function to identify whether the strings appear in the list.
Then either without VBA (or indeed with VBA) Autofilter your data for the matches, select the filtered rows and delete them.
OR modify your existing code but use the helper column.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks for your help and input
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks