I have a worksheet change event so that when information is entered into
C2:C50 it will put relative data into E2:E50. except something is not
working. It's activating for every cell change on the entire sheet.
here's what I got:
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "C2:C50"
On Error GoTo ws_exit:
Set OldCell = Target
Application.EnableEvents = False
If Target <> "" Then
With Target
CHANGECYCLE
End With
Else
GoTo ws_exit:
End If
Application.EnableEvents = True
ws_exit:
End Sub
The sub it goes to works as it should, but I only want it to work if the
C2:C50 is selected. What did I goof?
Bookmarks