I have the following VLOOKUP, which is working on a Range "Sub FindReplace_With_Offset_1"

I need to run it Cell by Cell on this range with a If-Statment "Sub FindReplace_With_Offset_2"

But I can not figure out how to alter
Please Login or Register  to view this content.
to only run cell by cell

Thank you

Please Login or Register  to view this content.
Please Login or Register  to view this content.