VBA Search First Number of a String

[Schwartz]

Hello,
I am trying to figure out a way to search a range, and if the first number of the string is "0", then delete that row.

so for example:

B1 = "0205650"
B2 = "1256056"
B3 = "9590004"
B4 = "0680506"


The macro would delete rows A1 and A4. Thanks!

This does not work (obviously), but I need the format something similar.

                      For t = lastrowtracker To 4 Step -1
        If Range(Left("b" & r),1).Value = "0" Then
        Rows(t).Select
            Selection.EntireRow.Delete

            Else
            End If
                 Next t

Thank you!

[Thalassa]

Try

Sub test()
Dim LR As Long, i As Long
LR = Range("B" & Rows.Count).End(xlUp).Row
For i = LR To 1 Step -1
    If Left(Range("B" & i).Value, 1) = "0" Then Rows(i).Delete
Next i
End Sub

[Schwartz]

That worked perfectly! Thank you for your help.