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.

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.

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.

Hi Jerry

Of course it can, how do you want to trigger the procedure?
By clicking on a button, or automatically after update, when
you open the Workbook??

Do you want it to be a specific cell, or any cell in the row?

i'll post the code, as soon as you post your preferences on
these questions!

Cheers Carlo


"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.

something like

for i=cells(rows.count,"a").end(xlup).row to 2 step -1
if cells(i,"a")=1 then rows(i).hidden=true
next

--
Don Guillett
SalesAid Software

"Jerrypetch" wrote in message
...
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.