currently i have my code checking a specific cell and hiding if that cell = 0
example:
I want to have my code check a range of cells and then if any of them = 0 i want it to hide the row its associated with.
Can anyone help me/??
THank you in advance
example:
Code:
If Sheets("Total Sheet").Range("a7:a7").Select = 0 Then
Rows("7").EntireRow.Hidden = True
End If
I want to have my code check a range of cells and then if any of them = 0 i want it to hide the row its associated with.
Can anyone help me/??
THank you in advance