I have a form that displays a list of items as per the users request and it works very well for me - i just need a little help with the following: The code below hides data in my sheet that the user is not interested in - what I want the code to do though, is IF there is no value in the range specified then do NOTHING. I imagine there needs to be an IF statement in my code below, something along the lines of IF Rng <> "" then ...... 

If ComboBox1.Value = "Company" Then
        'Application.ScreenUpdating = False
         Set rng = Range("B193", "B250")
         For Each cel In rng
         cel.EntireRow.Hidden = False
         Next cel
         For Each cel In rng
         If Not cel.Value = "Company" Then
        cel.EntireRow.Hidden = True
         End If
         Next cel
    End If