First column that does not contain "Cucumber"

[umop apisdn]

Hi,

I have 100 columns. How do I find the first column that does not contain
any cell with the value "Cucumber".

Thanks for any help,

Rob

 

[Don Guillett]

one way

Sub findnot()
For Each c In Range("c6:g6")
If ucase(c) <> "CUCUMBER" Then MsgBox c.Column: Exit Sub
Next
End Sub

 

[Frank Kabel]

Hi
for a formula approach try something like the following array formula
(entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:X100="Cucumber",COLUMN(A1:X100))