Thank You very much, that's exactly what I needed.

"Allllen" wrote:

Yes

If Range("B6").Value < 1 Then Range("B6").EntireRow.Hidden = True
--
Allllen


"Jerrypetch" wrote:

Can visual basics hide rows based on cell values? If for example a specific
cell has a value less than 1, then the entire row is hidden.