Trying to hide rows with multiple ranges

[cbh35711]

Any idea how i can get the following to work as a single line? I keep getting Type mismatch. I know i can break it apart, but that seems less fun.

Please Login or Register  to view this content.

Thanks all.

[mgs73]

Try this:

Please Login or Register  to view this content.

[Trebor76]

Try this:

Please Login or Register  to view this content.

Regards,

Robert