View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paige Paige is offline
external usenet poster
 
Posts: 270
Default Target Address/Value Macro Won't Work

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