Finding the Excat text in a range

Hi,

At the moment I am using the following code to find specific string in a range.

Set found = roster_list.Find(temp)

The problem is that even if there is a cell in roster_list with the value "0.5" but my temp is "0", it says that my text was found. How can i make sure that it matches the whole term.

Please help!

Hi! Try the following:

Set found = roster_list.Find(temp, LookAt:=xlWhole)

regards...

Originally Posted by schoujar

Hi,

At the moment I am using the following code to find specific string in a range.

Set found = roster_list.Find(temp)

The problem is that even if there is a cell in roster_list with the value "0.5" but my temp is "0", it says that my text was found. How can i make sure that it matches the whole term.

Please help!

Thanx, that worked!

Originally Posted by T-容x

Hi! Try the following:

Set found = roster_list.Find(temp, LookAt:=xlWhole)

regards...