I have the following code

Private Sub Worksheet_Change(ByVal Target As Range)
Dim lop, freq, per As Range
'Dim updatedCell As Range
'Set updatedCell = Range(Target.Dependents.Address)
If Not Intersect(Target, Target.Worksheet.Range("$F$5")) Is Nothing Then
Application.EnableEvents = False
'If Not Intersect(updatedCell, Range("F5")) Is Nothing Then
Set lop = Worksheets("ezhil").Range("I4")
Set freq = Worksheets("ezhil").Range("F5")
Set per = Worksheets("ezhil").Range("I5")
If freq.Value <= 0.0625 Then
MsgBox ("I'm in less")
 If per.Value = "4" Then
  lop.Value = "0.5"
 ElseIf per.Value = "5" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "6" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "7" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "8" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "9" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "10" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "11" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "12" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "13" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "14" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "15" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "16" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "17" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "18" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "19" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "20" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "21" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "22" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "23" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "24" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "25" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "26" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "27" Then
  lop.Value = lop.Value + 0.5
 End If
End If
If freq.Value > 0.0625 Then
MsgBox ("I'm in high")
 If per.Value = "1" Then
  lop.Value = "0.5"
 ElseIf per.Value = "2" Then
  If lop.Value = "0.5" Then
   lop.Value = lop.Value + 0.5
  Else
   lop.Value = "0.5"
  End If
 ElseIf per.Value = "3" Then
  If lop.Value = "0.5" Then
   lop.Value = lop.Value + 0.5
  ElseIf lop.Value = "1" Then
   lop.Value = lop.Value + 0.5
  Else
   lop.Value = "0.5"
  End If
 ElseIf per.Value = "4" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "5" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "6" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "7" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "8" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "9" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "10" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "11" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "12" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "13" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "14" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "15" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "16" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "17" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "18" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "19" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "20" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "21" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "22" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "23" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "24" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "25" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "26" Then
  lop.Value = lop.Value + 0.5
 ElseIf per.Value = "27" Then
  lop.Value = lop.Value + 0.5
 End If
End If
End If
Application.EnableEvents = True
End Sub
I have a formula in the cell "F5" which is used in the "intersect" method. when the value of the cell "F5" is changed based on the formula which depends on many other cells in the worksheet the following code should be executed. But it doesn't happen.Please help me with this "intersect" method.