| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to check if range contains particular word
i need to check via macro to see if range"A1:A20" contains a particular word
.. the word comes from another range via ....for each cell in range |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to check if range contains particular word
If IsError(.Match(cell.Value, myRng, 0)) Then 'not found Else 'found End If -- HTH Bob Phillips "Sunil Patel" wrote in message ... i need to check via macro to see if range"A1:A20" contains a particular word . the word comes from another range via ....for each cell in range |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to check if range contains particular word
if a whole word match (the cell contains only that word):
if application.Countif(Range("A1:A20"),Range("B9")) 0 then if not, post back. -- Regards, Tom Ogilvy "Sunil Patel" wrote in message ... i need to check via macro to see if range"A1:A20" contains a particular word . the word comes from another range via ....for each cell in range |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check for a word | Excel Worksheet Functions | |||
| Paste Word Check Box Form Field Link into Excel | Excel Discussion (Misc queries) | |||
| I need a bank check template for word or excel | Excel Discussion (Misc queries) | |||
| Auto spell check as in word | Excel Discussion (Misc queries) | |||
| Check if a range is a sebset of another range | Excel Programming | |||
Hybrid Mode
