why does this not work comparing the 2 cell values?

[aragon123321]

What is wrong with this?
I want to compare my values from a range to a single cell.
My Value for Cell 22,2 is 4





Dim Cell, Result As String, I As Long


For I = 3 To 17


If Cells(I, 2).Value > Cell(22, 2).Value

Then
Call Step2(" Error")
Exit Sub

 

[Joe4]

How is it not working? Are you getting error messages (if so, what do they say), or are you just getting unexpected results?

For one, the "IF" and "THEN" need to be on the same line, and then you need an "END IF" at the bottom to close it out (unless you have it all on one line).
See: http://www.excel-easy.com/vba/if-then-statement.html

You also need a "NEXT" to go along with your "FOR".

Secondly, we don't know what your Step2 procedure does (you haven't posted that code).

 

[ranman256]

For I = 3 To 17
    If Cells(I, 2).Value > Cell(22, 2).Value   Then    Call Step2(" Error")
next
Exit Sub

 

[aragon123321]

oh my it wasnt working cause i put Cell, instead of Cells.

Srry, im still getting use to vba.

Thanks for help!