Hello From Steved

Set FoundCell = Sh.Columns(1).Find( _
what:="2220")

At the moment the Above only finds a single Value.

Can I expand it to find 3 Value's in the same row please.
The "2220" Value is in Col A But Value "267"and "6.00"
is between Col B and Col AK in the same Row.

Set FoundCell = Sh.Columns(1).Find( _
what:="2220","267","6.00")

Thankyou.