View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default 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