silverskye787
Board Regular
- Joined
- Jun 18, 2007
- Messages
- 109
I have some problem with this set of codings
can someone help me?
cell Range A19:B22 cannot be cleared if A17 has a number 1
can someone help me?
Code:
If A17 = 1 Then
Range("A19:B22").ClearContents
ElseIf A17 = 2 Then
Range("A20:B22").ClearContents
Else
End If
cell Range A19:B22 cannot be cleared if A17 has a number 1