Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim derlig&
derlig = Range("A" & Rows.Count).End(xlUp).Row
If Application.Sum(Range("L8:L" & derlig)) = [O3] Then _
If Not Intersect(Target, Range("A" & derlig + 1 & ":O" & Rows.Count)) _
Is Nothing Then [A1].Select
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim dercel As Range, derlig&
Set dercel = [A:O].Find("*", , xlValues, , xlByRows, xlPrevious)
If dercel Is Nothing Then Exit Sub
derlig = dercel.Row
If derlig > 7 And Application.Sum(Range("L8:L" & derlig)) = [O3] And _
Not Intersect(Target, Range("A" & derlig + 1 & ":O" & Rows.Count)) _
Is Nothing Then [A1].Select
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim dercel As Range, derlig&
Set dercel = [A8:O30].Find("*", , xlValues, , xlByRows, xlPrevious)
If dercel Is Nothing Then Exit Sub
derlig = dercel.Row
If derlig < 30 And Application.Sum([L8:L30]) = [O3] And Not _
Intersect(Target, Range("A" & derlig + 1 & ":O30")) Is Nothing Then [A1].Select
End Sub