comparing numeric of both cells

[Joe C]

I want to compare 2 cells values in an if in vba

If cells(x,2) = cells(v,4)

Both cells are going tobe numerics, but there might be instances where the cell is considered text.

How would I write something to compare the values below does not seem to work

if cells(x,2).value = cells(v,4).value then

 

[VoG]

Try

If Val(Cells(x, 2).Value) = Val(Cells(v, 4).Value) Then

 

[Joe C]

That's a lot of Val.

Thanks so much I would have needed VALium before I ever thought of that.