G Guest Sep 11, 2006 #1 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? If for example a specific cell has a value less than 1, then the entire row is hidden.
G Guest Sep 11, 2006 #3 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
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 Sep 11, 2006 #4 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
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