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

Originally Posted by jraj1106

Run the macro and check...

Attachment 152742


Regards..

Hey Thanks, \m/

The code runs fine, but I had another query, what If I had to use two subroutines, first one for copying from sheet1 to sheet2 and then checking for multiple substrings in the sheet2 (as above) , how would that be done?

Thanks,
Abhushan.