Macro to jump to next blank with a criteria

hi

it's still the same, despite without the question.

At first run, it works, till the last blank. After that, it will not work anymore. It just always jumps straight to the last blank thereafter.

Perhaps it might be a structural issue with the code? although i'm no expert with codes. I'm thinking, the code needs to go back to the start after reaching the last blank BP that meets criteria? I mean, it has to allow user to keep repeating (START ALL OVER AGAIN) the process every time it has finished running through the range BP9:BP lastrow