Another Deleting Rows that do not Contain specific word....

Good morning,
I am afraid its another newbe to the forum looking for a generous helping hand!! I have a basic spreadsheet where one column contains a string of text (can be any length)
I am looking to run a Macro that will run through this Column (Column "L") to remove any rows that DO NOT contain the words "open" OR "OPEN" OR "Open".

I have looked through the forums and have the following code. But nothing happens when I run it:

Please Login or Register  to view this content.

Is this code something that can be amended? I am thinking it does work as it worked for someone else who posted, so I am doing something wrong even for just the one keyword search.

I appreciate any help you can offer me.

Thanks

Ben

Will this work for you? Try on a copy first.

Please Login or Register  to view this content.

How does your data structure looks like?
Which row is it starting from?
Is there a header row?
Or you can just attach a sample workbook for reference.

I have no idea why is that error occurring for you, can't duplicate it on my side. I attached a sample workbook to show that the code works, I also made some amendments to handle case where there are no rows to be deleted at all.

Please Login or Register  to view this content.