lundi 28 mai 2018

Simple If statement VBA

I am getting "End if without block if" while executing below code. I have no idea why.Please help.

If erange.Offset(0, 1).Value = "RTN" Then
    If erange.Value = "RASP" Then erange.Offset(0, 11).Value = "a"
    If erange.Value = "FEATHER EDGE" Then erange.Offset(0, 11).Value = "b"
    If erange.Value = "BIG TAPER" Then erange.Offset(0, 11).Value = "c"
    If erange.Value = "SQ & 3SQ" Then erange.Offset(0, 11).Value = "d"
    If erange.Value = "SMALL FLAT" Or erange.Value = "BIG FLAT" Or erange.Value = "BIG MILL" Or _
    erange.Value = "SMALL MILL" Then erange.Offset(0, 11).Value = "e"
    If erange.Value = "HALF ROUND" Then erange.Offset(0, 11).Value = "f"
    If erange.Value = "CHAINSAW" Then erange.Offset(0, 11).Value = "g"
    End If
End If

Aucun commentaire:

Enregistrer un commentaire