Solved: Find does not do an exact match

[JimS]

The line of code below uses a Data Validation list to pick a Hyperlink to open based on the users selection.

Is there away to ensure that it does a complete match?

The choices are similar (ie: MidWest, SouthWest, West) and this code does not pick the correct hyperlink.
For example when West is selected in the Data Validation cell the code opens the MidWest hyperlink.

Thanks...

JimS



ActiveWorkbook.FollowHyperlink Range("Areas").Find target.Value).Hyperlinks.Item(1).Address

[Aflatoon]

You ought to specify the
lookat:=xlWhole argument of the Find method.

[JimS]

Perfect - Thanks...