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

Originally Posted by jraj1106

For me th code works perfect. There's no error..

Well, it isnt working as my data consists of a lot many other entries which are numeric, alphanumeric and all mixed together, I cant share the excel as it is confidential. Anyways If you get a hint about why this Type Mismatch is arising, then please do let me know.

Could you please let me know if I could check multiple conditions i.e., in addition to "good morning" I want to check for 3-4 more conditions, how could I do that? Please help..

Originally Posted by Abhushan86

Could you please let me know if I could check multiple conditions i.e., in addition to "good morning" I want to check for 3-4 more conditions, how could I do that? Please help..

Please help....