Hi All,
I'm trying to find the word supplier in a range named HeaderRange1 as below. I want to use this as a way of stopping the macro proceeding further if it can't find the word "supplier" using the on error goto method.
HeaderRange1.Find(what:="Supplier", LookIn:=xlValues).Activate
However, it seems to be finding headings such as "Supplier Rate" and therefore reporting no error when the word "supplier" is missing. How can I modify the code above to just look strictly for the word "Supplier" and not "Supplier Rate"?
Thanks
Consult-S
I'm trying to find the word supplier in a range named HeaderRange1 as below. I want to use this as a way of stopping the macro proceeding further if it can't find the word "supplier" using the on error goto method.
HeaderRange1.Find(what:="Supplier", LookIn:=xlValues).Activate
However, it seems to be finding headings such as "Supplier Rate" and therefore reporting no error when the word "supplier" is missing. How can I modify the code above to just look strictly for the word "Supplier" and not "Supplier Rate"?
Thanks
Consult-S