You have two procedures with the same name in that module.

Depending on what they do, you can delete one (maybe it's not useful
anymore???). Or you'll have to combine the code into one procedure.

And watch your typing. I bet the minus in this line was supposed to be an equal
sign:
Selection.EntireRow.Hidden -False


Marilyn wrote:

Hello
I created the code below but it does not work - gives the error of
"Ambiguous name detected: worksheet_Change"

so, this is what I want .... for this worksheet only
if cell B 29 equals "Spec" or "blanket" then unhide rows 35 thru 37 if cell
B29 equals "Biology" then unhide row 34

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("B29").Address Then
If Target = "Spec" Or Target = "Blanket" Then
Rows("35:37").Select
Selection.EntireRow.Hidden = False
If Target = "Biology" Then
Rows("34").Select
Selection.EntireRow.Hidden -False
End If
End If
End If

End Sub
thank you so much

--

Dave Peterson