If Range("C1") is in MyArray
Thanks, Juan, for your help.
I'm too ignorant to use your method, but will try it when I understand it.
The following code seemed to "work" for me:
For H = 1 To 12
If Range("F" & N) = MyArray(H) Then
(do something)
End If
Next
st.
"Juan Pablo Gonzalez" wrote in message
...
My usual approach is
If IsNumeric(Application.Match(Range("C1").Value, MyArray, 0)) Then
'Is in the array
End If
--
Regards,
Juan Pablo González
"zSplash" <zNOSPAMSplash@ gci.net wrote in message
...
Being very unfamiliar with arrays, but impressed with their worth, I am
trying to code with an array. I have defined MyArray, and now want to
check
to see if the cell value in "C1" is the same as any of my array values.
How
do I code that?
Say: MyArray("one", "two", "three", "four", "five", "six", "seven",
"eight")
If Range("C1").value = [...is in MyArray] then
(do something)
End
How do I test for C1's value being in MyArray? (Sorry if this is
unclear;
I
am very trying...)
TIA
|