| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a range contains a certain value
Hello,
A newbie question I have a range named GRID (3 columns x 10 rows). Can someone give me some code with which i can check if there is a certain value in that range. Example : I want to check if the GRID contains the value A. IF it contains A THEN some actions have to follow. If the GRID contains the value B some other actions have to follow. .......... .......... If the GRID contains the value Z some other actions have to follow. Thanx for your replies |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check i a value is in a Range | Excel Programming | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| Check if a range is a sebset of another range | Excel Programming | |||
| Check if a range is a sebset of another range | Excel Programming | |||
| check range for certain value | Excel Programming | |||
Threaded Mode
