Thanks again but still struggling.

What the top code did was find the 1st instance of "UOM" in H25 for example, then open Userform2, do its thing then jump to say H46, open Userform2 and so on. This code doesn't seem to select he 1st instance

Thanks in Advance