Search VBA

hi, the following code search's for the Term "UOM" in a range of cells and if this is there then opens Userform 2 which allows the user to change certain data then writes to a different sheet. It then continues on it search until all instances of "UOM" have been found. What I'm struggling with is when it reaches the last instance of "UOM" it returns to the first instance and starts again.

Is there anyway of stopping at the last instance??????????

Thanks

Please Login or Register  to view this content.

Try something like this...

Please Login or Register  to view this content.

Thanks, but that doesn't seem to want to search from H5 down till the last used row in column H.

Any ideas??

Thanks

Please Login or Register  to view this content.

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

Originally Posted by zhb12810

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

If the first code worked then what was the problem?

Did you have the correct sheet activated when you ran the second code?

When it got to the last instance of the search term it returned to the start of the list and started searching through the same again. Basically i just want it to only ever search the range once.

Once the search has completed another routine will run and refresh the data so that the search term should be obsolete. As more data is added the search term may reappear and the process will start again

Thanks

This searches once.

Please Login or Register  to view this content.