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!


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=398494

Finding the Excat text in a range
 

Hi! Try the following:

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

regards... ;)

schoujar Wrote:
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!


--
T-®ex
------------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=398494

Finding the Excat text in a range
 

Thanx, that worked!

T-®ex Wrote:
Hi! Try the following:

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

regards... ;)


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=398494