Search routine

[dschmitt]

The below script takes a strings from one column (cell by cell) and compares it with strings in another column. If it finds a match it creates a hyperlink between the two cells.

With this script I have one problem. I will give an example.
Lets say the seach string is "link". The script will create a hyperlink to any cell that contains this string, even for example to "blinker".
That is not good. Is there a way to modify this code so that hits are limited to exact matches?

Please Login or Register  to view this content.

[dschmitt]

found the solution.

change LookAt:=xlPart to LookAt:=xlWhole