Hi all,
Unfortunately I am not familier with VBA so I would like to ask you for your kind help.
I have data in column Z where is TRUE or FALSE. No other.
I need to erase a cell in X column on the same row if FALSE appears in Z column.
I need to make it in VBA. I cannot use data validation because I already use it for different conditions.
Thank for any idea.
The whole what I have is this wrong code:
Private Sub Worksheet_Change(ByVal Target As Range)
Set x = ActiveSheet.Range("Z1:Z10")
Set y = ActiveSheet.Range("X1:X10")
For Each c In x
If c.Value <> "TRUE" Then
y.ClearContents
End If
End Sub
Bookmarks