Look for value in part of cell

[mattress58]

I have the code below that works, but I am coping this like 100 times and changing the value "ALBT01 Total" to the next cells value that has "xxx total". How can I add something that will do the exact code below that just finds "Total" anywhere in the cell and keeps going so I can only write this one instead of 100 times in my module.

Please Login or Register  to view this content.

[ragulduy]

You can use instr, for example:

Please Login or Register  to view this content.

[mattress58]

That worked.... Amazing. Thanks