Amend Value to ABS

[somesoldiers]

Hi Guys

I need to amend below code so that for Column N the code will include if the value of ABS((N-(N-1)) <=2 but whereever I put the ABS seems to give an error.

Appreciate any help

thanks

Noel

  If .Range("H" & i).Value = .Range("H" & i + 1).Value And _
        .Range("G" & i).Value = .Range("G" & i + 1).Value And _
        .Range("J" & i).Value = .Range("J" & i + 1).Value And _
        .Range("M" & i).Value = .Range("M" & i + 1).Value And _
        .Range("N" & i).Value - .Range("N" & i + 1).Value <= 2 And _
        .Range("O" & i).Value = .Range("O" & i + 1).Value Then

 

[VoG]

Try

If .Range("H" & i).Value = .Range("H" & i + 1).Value And _
        .Range("G" & i).Value = .Range("G" & i + 1).Value And _
        .Range("J" & i).Value = .Range("J" & i + 1).Value And _
        .Range("M" & i).Value = .Range("M" & i + 1).Value And _
        Abs(.Range("N" & i).Value - .Range("N" & i + 1).Value) <= 2 And _
        .Range("O" & i).Value = .Range("O" & i + 1).Value Then

 

[somesoldiers]

That's it, thanks Peter