thanhvanchi
12-10-2016, 12:04 AM
Hello everyone!
Please help configure out this code. If the first code condition are OK the 3Spring will display in the S448 address(cell),
but if the first code are not satisfied. The second condition will
applied in the same address.
If sh1.Range("S448") = "N" Or sh1.Range("S448") = "ONT" Or sh1.Range("S448") = "PON" Then b = "3Spring"
Else: sh1.Range("S448") = "Nest3" Then b = "4Spring"
Thank's a lot!
Please help configure out this code. If the first code condition are OK the 3Spring will display in the S448 address(cell),
but if the first code are not satisfied. The second condition will
applied in the same address.
If sh1.Range("S448") = "N" Or sh1.Range("S448") = "ONT" Or sh1.Range("S448") = "PON" Then b = "3Spring"
Else: sh1.Range("S448") = "Nest3" Then b = "4Spring"
Thank's a lot!