Am I killing the event when I exit the sub? Meaning, if you click a cell and the Target.Value > 0 it works as it should, but the second a cell is clicked and the Target.Value = 0 the Debug.Print line is no longer hit, and the Sub is no longer called when a cell is clicked where Target.Value >= 1 w/o closing and reopening the workbook.
Should this be set-up differently?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Value = 0 Then Exit Sub
Debug.Print Range("A" & Target.Row)
End Sub
Bookmarks