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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a range contains a certain value
What I do is something like this
For each c in (range) if c.value = "A" then else end if next "Luc" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if a range contains a certain value
dim myRng as range
set myrng = worksheets("sheet1").range("Grid") if application.countif(myrng,"A")0 then 'it's there else 'it's not there 'same check for B.... end if If I were checking A to Z, I'd use something like: Option Explicit Sub testme() Dim myRng As Range Dim iCtr As Long Set myRng = Worksheets("sheet1").Range("Grid") For iCtr = Asc("A") To Asc("Z") If Application.CountIf(myRng, Chr(iCtr)) 0 Then 'found it 'do what you want MsgBox "Found: " & Chr(iCtr) Exit For 'stop looking End If Next iCtr End Sub Luc wrote: 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 -- Dave Peterson |
Reply |
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 |