Marco to hide rows based on critera in another row

Hello.

Do you really need a macro to be able to do that? Can't you use a AutoFilter and select (for example in column B) blank cells only?
And when you want to see Deselect the blank cells in the same column or remove the Autofilter.


P.S: Maybe it's more complex than that and I did missunderstood your doubt. If that was the case, my apologies


Kind Regards,
FCarv