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