Unhide/Hide Next Row if Cell Is Blank/Not Blank

Greetings,
I am using the following code to unhide/hide the next row if the cells in Column B are blank/not blank (rows 16 - 77). The unhide portion of the code only works when I click in the cell after typing. However, the hide portion works immediately after deleting the contexts of the cell.

Please Login or Register  to view this content.

Does this work for you?
When you change a cell in column B

Please Login or Register  to view this content.

ByteMarks,
Thank you for your reply and I apologize for not responding earlier.
Your code works great in hiding the rows if the cell in the above row is blank. However, it does not unhide the row if the cell is not blank. I have been working on modifying your code, but my VBA skills are limited.

Your code works great in hiding the rows if the cell in the above row is blank.

It shouldn't do based on Unhide = Blank and Hide = Not Blank
If you take B17 for example. Populating it should hide row 18. Deleting the contents should reveal row 18

If that's not correct then perhaps I've misunderstood the requirement?

I am so sorry. It should be based on Unhide = Not Blank and Hide = Blank. I had it backwards.

Ah ok.

Try it like this.

Please Login or Register  to view this content.

Works Perfect!!
And I see why. By adding the " = 0" to the end of the code, it changes the True to False. Thus reversing the Hidden.
Again, thank you very much. I have learned a valuable lesson!!!
By the way, I tried to give add an Add Reputation, but would not allow.

Happy to help.

On the original (incorrect) code, you could have written it as follows, which gives a bit more context to =0 in the reversal.

Please Login or Register  to view this content.

Is it possible to use this code with merged cells.

Forget my previous post - I had incorrectly set the starting row.