Hide rows based on Drop-down box selection

Hide Rows Based on Dropdown using Worksheet Change

It seems to me that you can simplify your code with

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$O$35" Then
        Rows("36:239").Hidden = (Target.Value = "VPN to VPN Cloud-Based")
    End If
End Sub

which is short for

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$O$35" Then
        If Target.Value = "VPN to VPN Cloud-Based" Then
            Rows("36:239").Hidden = True
        Else
            Rows("36:239").Hidden = False
        End If
    End If
End Sub

If you plan to add more 'true' cases, you could use

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$O$35" Then
        Select Case Target.Value
            Case "VPN to VPN Cloud-Based" ' more cases here
                Rows("36:239").Hidden = True
            Case "Please Select", "Leased Line", "Custom Network", "N/A", _
                    "Please Select:" ' , "" ' ???
                Rows("36:239").Hidden = False
            Case Else ' what about any other cases, e.g. "" (vbNullString)???
                Rows("36:239").Hidden = False ' ???
        End Select
    End If
End Sub

Rather use the Else case instead of the 2nd case.

Could you please share:

Your current VBA code (you can paste it as text)

Details about your dropdown:

Is it a Data Validation dropdown or an ActiveX/Form Control?

Which cell contains the dropdown?

What's the exact text of the selection options?

Additional: Which operating system?

Which Office version?

In this link you will find some more information about it:

Welcome to your Excel discussion space!

So no one needs to guess and exclude many ways/causes with a lot of communicative time.

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)