I am very new to vba and macros and I am trying to clear cells automatically when another cell gets a value put into it. An example would be: If C3 has a value, clear B3, but I'd like it to do that to an entire table range. I've used this code:
Sub CLEARCELLS()
If Sheet1.Range("C3").Value <> "" Then
Sheet1.Range("B3").ClearContents
End If
End Sub
It works perfect for that particular cell, but I need it to cover all of column B & C and I'm pretty stuck since this is all new to me. Any help would be appreciated, thank you.
Sub CLEARCELLS()
If Sheet1.Range("C3").Value <> "" Then
Sheet1.Range("B3").ClearContents
End If
End Sub
It works perfect for that particular cell, but I need it to cover all of column B & C and I'm pretty stuck since this is all new to me. Any help would be appreciated, thank you.