Auto Hide and Unhide Rows Based

I will have to work on this some more .. just cant seem to get the code to unhide when a value is in cell C12..

Originally Posted by moonsaga

I will have to work on this some more .. just cant seem to get the code to unhide when a value is in cell C12..

Thanks! That's also my problem whenever a value is present in C12 it does not unhide. That is why I posted it here for possible solutions.

I think i got it working now...

Private Sub worksheet_SelectionChange(ByVal Target As Range)
    Dim cn As Range
    Set cn = Range("C12")
    On Error GoTo endbit:
        If cn.Value = CVErr(xlErrNum) Then
         Rows("1:13").EntireRow.Hidden = True
        Exit Sub
endbit:
        On Error Resume Next
        Rows("1:13").EntireRow.Hidden = False
End If
End Sub

the above code will hide the row range when there is the #NUM! error in C12 of the Summary sheet and if there is no #NUM! error in C12 on the Summary sheet it will unhide the row range.
I hope this works for you. let me know.