Sub Mac()
Rows(10).Hidden = IIf(Range("E2") = "Yes", True, False)
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Jeremy" wrote:

I have recorded a macro to hid row 10. How would I automate this macro to
hide if E2 has yes and unhide if it has no?


Thank you

Jeremy