Macro needed to hide rows within multiple ranges if the cell value in each row is blank

Hello

Apologies if this has been answered elsewhere, but I've had a dig around several forums this afternoon and cannot find anything that seems to work for this purpose..

I have a number of row ranges within a worksheet that I would like this to apply to..

Rows 5-20
Rows 27-42 and
Rows 49-90

I would like to hide the rows in each of these ranges if a blank value is returned by the formula in column B (of each row).

Hopefully that makes sense.. If you need any other info then please let me know.

Really appreciate any assistance anyone can offer.

Regards
Tom

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Many thanks, stnkynts. Works perfectly!