Find Function Not Searching Whole Cell, Only Start of Cell

Hi All,

So I must be overlooking something very simple in my code here but for the life of me I can't seem to remember what it is.....
I have a search function that searches cells for data from an inputbox, and then highlights that entire row. It's working great if the string is at the start of the cell, not so great if it's somewhere in the middle.

e.g. inputbox value = "123"
that will highlight cell "123456" or cell "123 test" but not cell "test 123"

I would really appreciate some advice on what part of the code needs adjusting so that I may go and start kicking myself.....

Please Login or Register  to view this content.

Maybe this?

Please Login or Register  to view this content.

Beth.

Hi Beth,

This is it!! Thank you so much, I knew it was the smallest thing I was missing but for the life of me I couldn't see it. I owe you a coffee Have a great day!!

No problem at all. Happy to help

Sometimes it just takes a new set of eyes.

Beth.