Stopping a Loop in a macro when a keyword appears.

[andrew93hughes]

Hi guys

I have this bit of code on the end of a macro, to calculate a value and move on to the next line. When Cells(i, 1).Value have "(blank)" written in the cell, I want to stop the loop, how do I do that?

Please Login or Register  to view this content.

Don't think having the workbook is essential to solving this, but if it's required i'll upload it

[JBeaucaire]

one way:

Please Login or Register  to view this content.

[fredlo2010]

Try this untested

Also modify I am not sure if you meant blank cell or string "(blank)"

Please Login or Register  to view this content.

Thanks

[andrew93hughes]

Thanks guys! I went for fredlo's one because I understood it better, (bit of a programming noob), thank you for the help!!

[fredlo2010]

You are welcome. This is the good part of VBA you can achieve same result using different methods. JBeaucaire used a different kind of loop.

I am wondering if there is a significant speed or gain between one or the other JBeaucaire? you are the expert here.

Thanks

[JBeaucaire]

Nah, a loop is a loop in this scenario. I'm a fan of DO loops.