| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check to see if a cell contains a certain word
what vba function can check if a cell contains a certain word? I trie the Search function, but it gives me an error message said undefine function. Thanks -- betty7 ----------------------------------------------------------------------- betty77's Profile: http://www.excelforum.com/member.php...fo&userid=3709 View this thread: http://www.excelforum.com/showthread.php?threadid=56931 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check to see if a cell contains a certain word
Look at Instr function.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "betty77" wrote in message ... what vba function can check if a cell contains a certain word? I tried the Search function, but it gives me an error message said undefined function. Thanks. -- betty77 ------------------------------------------------------------------------ betty77's Profile: http://www.excelforum.com/member.php...o&userid=37092 View this thread: http://www.excelforum.com/showthread...hreadid=569310 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Check for a word | Excel Worksheet Functions | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Check if Word is already active? | Excel Programming | |||
| how to check if range contains particular word | Excel Programming | |||
![betty77[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
