Sub test()
Dim rng As Range
Dim n As Integer
Dim i As Integer
Set rng = Range([e1], Range("e65536").End(xlUp))
If Not rng Is Nothing Then
n = rng.Count
For i = n To 1 Step -1
If rng(i) <> 0 Then
If Asc(rng(i)) < 0 Then
Cells(rng(i).Row + 1, 1).Select
End
End If
End If
Next
End If
End Sub
Sub test()
Dim rng As Range
Dim n As Integer
Dim i As Integer
Set rng = Range([e1], Range("e65536").End(xlUp))
If Not rng Is Nothing Then
n = rng.Count
For i = n To 1 Step -1
If rng(i) <> 0 Then
If Asc(rng(i)) < 0 Then
Cells(rng(i).Row + 1, 1).Select
End
End If
End If
Next
End If
End Sub