FuzzyVlookup messing up Worksheet Change

[zoomixer]

Hi! I'm a noob when it comes to using VB with Excel and everything I do I've ripped off of other people. That being said I was trying to implement the FuzzyVlookup that I've seen posts about on here into a workbook. When I added it worked just wonderfully but it ended up for whatever reason causing my Worksheet Change that I had to hide or show rows/tabs based on certain values on the sheet. Here's the basics of what I have:

Private Sub Worksheet_Change(ByVal Target As Range)
'If Target.Count > 1 Then Exit Sub
If (Target.Address <> "$M$2") And (Target.Address <> "$C$10") And (Target.Address <> "$C$40") Then Exit Sub
'change this address
Dim myrow As Integer
myrow = Target.Row
If Target.Value = "1 Driver" Then
Range(myrow + 5 & ":" & myrow + 28).EntireRow.Hidden = True
'add/change row names
End If

and it continues from there with further variables. Can anyone assist me with getting this code to work along with the FuzzyVlookup? Also, some pointers as to why it's not working would be appreciated Thanks!

 

[zoomixer]

I just noticed I messed up my original post. The FuzzyVlookup is causing my Worksheet Change to NOT work. They work fine independently of each other but not together.

 

[zoomixer]

I could really use some help with this one if anyone has any ideas. Thanks!