How to use two code into one Excel VBA
I think your logic is wrong - you've got
- if the value is zero, hide the row
- otherwise (i.e. if the value is not zero), if the row is hidden, show it.
Does this do more what you want:
Sub HideRows()
Dim cell As Range
For Each cell In Sheets("Current Assets").Range("Table110[Qty.]")
If cell.Value = 0 Then
cell.EntireRow.Hidden = Not cell.EntireRow.Hidden
End If
Next
End Sub