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-容x
------------------------------------------------------------------------
T-容x's Profile:
http://www.excelforum.com/member.php...o&userid=26572
View this thread:
http://www.excelforum.com/showthread...hreadid=398494