Select each row one by one and check for a substring in each cell of it

Originally Posted by jraj1106

Try this code:

Hi, when I run this code It shows me a type mismatch, is it because of the space condition that we are checking for?

Also another thing, how do I check for multiple conditions in this itself, I mean to say that If in addition to "good morning" I want other phrases as well, say for example "good day" or "good night" then also I need to delete that row.