Hi
only possible with VBA but not with formulas. But why not use a filter
'Data - Filter - Autofilter' for this


--
Regards
Frank Kabel
Frankfurt, Germany

"Bob" schrieb im Newsbeitrag
...
if I have a worksheet with two columns A and B. and there is no
information
in Column B I would like to leave it. If there is information in
Column B,
I would like to hide the row.

Column A Column B

ABC
DEF CCC I would like to hide this row.

Is this possable. thanks for any help.