Toggle Hide Row Based on Column Data

[thesonofdarwin]

I'm looking to have a macro that will hide all rows where the cell in column B of that row is blank. The formulas in those cells are returning "" if there isn't a calculated value. I'd like that macro to also unhide all rows if there are currently rows hidden in the range. However, I'm having trouble simply getting the rows to hide. I tried the following:

Please Login or Register  to view this content.

That didn't work, so I thought "" might be returning as Null and tried the following, which also did not work.

Please Login or Register  to view this content.

Any suggestions?

[thesonofdarwin]

In the spirit of helping the next person looking for this type of solution, I decided to use an ActiveX togglebutton to achieve what I was looking to do. The following code works:

Please Login or Register  to view this content.

There may be a faster/better way of handling this, but for my purposes this will work. If I were working with thousands of rows this would likely become cumbersome.