Can visual basics hide rows based on cell values?
 

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.

Can visual basics hide rows based on cell values?
 

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.

Can visual basics hide rows based on cell values?
 

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.

Can visual basics hide rows based on cell values?
 

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.

Can visual basics hide rows based on cell values?
 

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.