Hello I have two option buttons one says yes the other No
SO if the option selected is yes I want to unhide row A32 thruA44 if No is
selected then rows A32 thru A44 remain hidden
this is what I have but it does not work
Private Sub OptionButton1_Click()
Dim myRng As Range

Set myRng = Me.Range("a32:a44")

myRng.EntireRow.Hidden = Not (myRng(1).EntireRow.Hidden)

End Sub
thanks for your help