| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search if a cell range contains a particular value
I'm trying to write a macro that will look at a selected range of cells and
if any of them contains a certain value, then a number 1 will be put in a paticular cell, say...B9. Here is what I have. Range("D" & (a) & ":D" & (b)).Select If Selection = "Test" Then Range("S" & a).Value = 1 It obviously doesn't work, but I'm looking for suggestions Thanks, Paul |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for specific text within last non blank cell in a range | Excel Worksheet Functions | |||
| Search Range for Criteria in given cell and produce results | Excel Discussion (Misc queries) | |||
| Search a Range for a phrase and Format cell if found | Excel Programming | |||
| Limit search range then loop thru' each cell...a bit stuck... | Excel Programming | |||
| search range, if exist, copy cell | Excel Programming | |||
Threaded Mode
