Macro to hide rows based on a range of data in a cell

Something like

Sub HideRowsIF()
    
    Dim ws1 As Worksheet
    Dim cRng As Range, oC As Range
    
    Set ws1 = Worksheets("Sheet1")
    Set cRng = ws1.Range(ws1.Cells(2, 17), ws1.Cells(ws1.Rows.Count, 17).End(xlUp))
    For Each oC In cRng
        If oC.Value > 99 And oC.Value < 106 Then
            oC.EntireRow.Hidden = True
        End If
    Next oC
    
End Sub

should do the job!