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.

Please Login or Register  to view this content.

Thank you!

[Thalassa]

Try

Please Login or Register  to view this content.

[Schwartz]

That worked perfectly! Thank you for your help.