| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding text in a range | Excel Discussion (Misc queries) | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Functions- Finding and counting specified text in cell range | Excel Worksheet Functions | |||
| Find WorksheetFunction - finding text within text | Excel Programming | |||
| Excat Forumla HELP | Excel Worksheet Functions | |||
Linear Mode
