function for zero values in cell (Excel 2000)

Topic

New Reply

Just loop through all the cells and check each cell for whatever conditions you want.

Reply | Quote

Replies

SpecialCells(xlCellTypeBlanks) seems to hide cells only if there actually blank which makes sense, is there a way to hide cells if the formula value is 0′ as well?

Reply | Quote

I figured that so I am using
For Each cell In Range(“E11:E91”)
If cell.Value = 0 Then
cell.EntireRow.Hidden = True
End If
Next cell

Thanks for the reply

Reply | Quote

That should work.

Reply | Quote