Q:

Compare value of cell in vba

I am trying to compare the value of a cell (always a number) to the iteration variable in a for loop but for some reason vba says this is an invalid call or argument.  I am new to vba so any help would be greatly appreciated.
For i = 2 To wb1.Sheets("Development Priority List").Rows.Count

If wb1.Sheets("Development Priority List").Cells("A" & i).Value < i - 1 Then
    wb1.Sheets("Development Priority List").Range("A" & i, "Z" & i).Delete
End If

Next i

A:

Your IF statement is incorrect.  Change to:
If wb1.Sheets("Development Priority List").Cells(i,1).Value < i - 1 Then

