"Unhide/Hide Multiple Rows if Cell = Value/No Value" Question

[MattyTBR]

Hello experts!

I have another question for you...

I'm trying to hide rows 175 through 278 if cell C63 does NOT equal any number value, and unhide rows 175 through 278 if cell C63 DOES equal any number value. I know I need a macro for this, and I need the macro to run if that cell value ever changes (rather than clicking a button to make the macro do its thing.)

I've tried to look for VBA code that would do something like this, and maybe it's just my lack of VBA coding knowledge, but I can't seem to make them work.

If any of you have any suggestions or advice, I'd love to hear from you.

Thank you very much in advance!

-Matty

 

[Marcelo Branco]

Hi,

Maybe this

Copy the macro below to the code-page of your worksheet

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("C63")) Is Nothing Then
        If Not IsNumeric(Range("C63").Value) Or Range("C63").Value = "" Then
            Range("A175:A278").EntireRow.Hidden = True
        Else
            Range("A175:A278").EntireRow.Hidden = False
        End If
    End If
    
End Sub

HTH

M.