|
残りの定義は、以下の通りです。空欄は、まだ定まっていない定義です。
'何も表示しない定義'
LN1 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 1)
LN2 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 1)
LN3 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 1)
LN4= (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 1)
LN5 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 1)
LN6 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 1)
LN7= (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 1)
LN8 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 1)
LN9 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 1)
LN10 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 1)
LN11 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 1)
LN12
LN13
LN14
'不具合A・B・C・・・定義'
LN15 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN16 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN17 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 0)
LN18 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 0)
LN19 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 0)
LN20 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN21 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "A") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 0)
LN22
LN23 = Cells(RR&, 13).Value = A
LN24 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN25 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN26 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 0)
LN27 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 0) And _ (Cells(RR&, 18).Value = 0)
LN28 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN29 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "B") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN30 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "C") And _ (Cells(RR&, 18).Value = 0)
LN31 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "C") And _ (Cells(RR&, 18).Value = 0)
LN32 = (Cells(RR&, 11).Value = 0) And _ (Cells(RR&, 13).Value = "D") And _ (Cells(RR&, 14).Value = 1) And _ (Cells(RR&, 18).Value = 0)
LN33 = (Cells(RR&, 11).Value = 1) And _ (Cells(RR&, 13).Value = "D")
LN34 = (Cells(RR&, 11).Value = 2) And _ (Cells(RR&, 13).Value = "D")
LN35
LN36
LN37
|
|