Set a macro to refresh after a change in a specific cell

[JAdamD]

I am a very basic VBA user but have the following code which hides rows based on a Yes/No outcome in a particular column:

Private Sub Worksheet_Activate()

StartRow = 10

EndRow = 19

ColNum = 2

For i = StartRow To EndRow

If Cells(i, ColNum).Value <> "Yes" Then

Cells(i, ColNum).EntireRow.Hidden = True

Else

Cells(i, ColNum).EntireRow.Hidden = False

End If

Next i

End Sub

I'm looking to have this refresh after cell A5 is updated.

Any guidance would be greatly appreciated.

 

[Micron]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$5" Then Worksheet_Activate
End Sub

Be aware that if you change "cat" to "cat" (edit results in same value) that will still call the other event.
Please use code tags (vba button on posting toolbar) to maintain indentation and readability.