Can visual basics hide rows based on cell values?

J

Jerrypetch

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

Carlo

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
 
D

Don Guillett

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
 
Top