Target Address/Value Macro Won't Work

[Guest]

I have a merged cell (C90:F90) to be used for text entry. It has a drop-down
for the user to select a response. If the user selects "via another method",
it should unhide row 91; if they select anything else, or delete an entry
already in there (that they inputted earlier perhaps), then row 91 should be
hidden. When I use the following code, it works except for when a current
entry is deleted - then I get a type mismatch error. Can someone please
advise what I've done wrong here?

If Not Intersect(Target, Range("C" & 90 & ":F" & 90)) Is Nothing Then
If Target.Value <> "via another method" Then
Rows("91").Hidden = True
Else
Rows("91").Hidden = False
End If
End If

 

[Tom Ogilvy]

If Not Intersect(Target, Range("C90:F90")) Is Nothing Then
If Target(1).Value = "via another method" Then
Rows("91").Hidden = False
Else
Rows("91").Hidden = True
End If
End If

 

[Guest]

Thanks, Tom - works like a charm - you are a peach!!!