Basic question on cell comparison

[yoelgr]

I am new to VBA, so this is probably a very dum question. I am trying to compare cells in one column to those in another. I.e. I choose a cell in one column, and I want to check if its content exists in the second column. Cells contain strings. I am writing:
For i = 0 To composerCount
If Cells(r, 9).Value = Cells(i, 20).Value Then
isNew = False
End If
I have also tried without the .Value, but neither work. What is the correct syntax?

[Bob Phillips]

That is how it is done, so what is the problem?

Maybe you just want t check if it exists in any row?

[vba]

For i = 0 To composerCount

isNew = IsError(Application.Match(Cells(r, 9).Value, Columns(20),0))
Next i
[/vba]

[yoelgr]

That is how it is done, so what is the problem?

Maybe you just want t check if it exists in any row?

[vba]

For i = 0 To composerCount

isNew = IsError(Application.Match(Cells(r, 9).Value, Columns(20),0))
Next i
[/vba]

Thanks for the reply. When I use the code I wrote, I get:
I get Run-time Error '1004': Application-defined or object-defined error.

[mdmackillop]

Can you post the whole of your code so we can see how IsNew is implemented.

[Bob Phillips]

Thanks for the reply. When I use the code I wrote, I get:
I get Run-time Error '1004': Application-defined or object-defined error.

I doubt that error is in that code.

As MD suggested, post the workbook or all the code for us to see.