Adding An Entry on Column H

Hello,

If an entry in B4:B3000 then H will have an entry "NO"


What to do, if I want to include this to the code below:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Thank you in advance!

How do I separate them. When I tried to make to Private Sub then it won't work.

Please Login or Register  to view this content.

This is for the H:

Please Login or Register  to view this content.