VBA Rookie Issue
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column < 5 Then
Exit Sub
Else
If Target < "" Then
Target.Offset(0, -2).ClearContents
End If
End If
End Sub
"Scott Wagner" wrote:
This should be an easy one for the enlightened.
If cell in column E is not blank, clear contents of corresponding cell in
column C.
Otherwise, do nothing.
Thanks for your brains,
Scott
|