Concatenate function in vba

I am trying to do the following:

Sub Sample()
For a = 1 To 100
r = concatenate(Cells(a, 1), Cells(a, 2))
If r = "Mr.Jones" Then
Cells(a, 3) = ""
End If
Next a
End Sub

There is more to it, but I can't seem to use the concatenate function.
"Left", "Right" are ok, but not this one it seems. What am I missing?

Thank you
Chris Cameron
[email protected]

you have to use the "&"

= Cells(a, 1) & Cells(a, 2)


"camerons" wrote:

> I am trying to do the following:
>
> Sub Sample()
> For a = 1 To 100
> r = concatenate(Cells(a, 1), Cells(a, 2))
> If r = "Mr.Jones" Then
> Cells(a, 3) = ""
> End If
> Next a
> End Sub
>
> There is more to it, but I can't seem to use the concatenate function.
> "Left", "Right" are ok, but not this one it seems. What am I missing?
>
> Thank you
> Chris Cameron
> [email protected]
>
>
>

One way:

Dim a As Long
For a = 1 To 100
If Cells(a, 1).Text & Cells(a, 2).Text = "Mr.Jones" Then _
Cells(a, 3).ClearContents
Next a


In article <[email protected]>,
"camerons" <[email protected]> wrote:

> I am trying to do the following:
>
> Sub Sample()
> For a = 1 To 100
> r = concatenate(Cells(a, 1), Cells(a, 2))
> If r = "Mr.Jones" Then
> Cells(a, 3) = ""
> End If
> Next a
> End Sub
>
> There is more to it, but I can't seem to use the concatenate function.
> "Left", "Right" are ok, but not this one it seems. What am I missing?
>
> Thank you
> Chris Cameron
> [email protected]

Thanks, I've got it working now.
What would you suggest for learning correct syntax for VBA?