Hide row if cell is empty

[jturman]

I am trying to write a program that hides the row in a table if the cell in column B is empty. The table goes from B11:B74.

I've tried some different programs I have found on other websites but none have worked so far. Any help would be greatly appreciated.

[JBeaucaire]

Lookup the TABLE features in Excel 2007 (like the AutoFilter in 2003). Once that is turned on for your data table, you can simply filter column B for non-blanks to hide all the blank rows.

No VBA needed.

[Jbm444]

Try this:

Please Login or Register  to view this content.

[jturman]

I changed it so that it made the decision based on the value of the cell in column A. This is what I came up with:

Please Login or Register  to view this content.

[foxguy]

[QUOTE=jturman;2341825]
Simplify UnHideRows

Please Login or Register  to view this content.