Macro Help
Can you help me with where to put this. Thank you for your response.
"Jacob Skaria" wrote:
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
|