Hey guys.
Guess it's not so advanced but I don't manage to get it to work.
What i wanna do is if a cell contains the value 0 I want it to hide a row, and if it contains something else then 0 (i.e 1 or 2 or 3 or 4~) I want to show the row.
The values are filled in Sheet1 and then shown on Sheet2.
Tried with this but doesn't work when it's on different sheets. But once in same sheet it do work.
Also, can you write the code different if I got more cells with values I want in the same code. Post back if you miss something.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("Sheet1!B4").Value = 0 Then
Rows("Sheet2!10").EntireRow.Hidden = True
Else
Rows("Sheet2!10").EntireRow.Hidden = False
End If
End Sub
Bookmarks