VBA to autohide row based on value for another tab

I am sorry if the answer for this is already been posted in the forum, my search results did not produce what I was looking for. I would like to have a marco that based on the information contained in cell A1 of sheet named "Input", it will either hide or unhide rows 26-27 of sheet named "Comparison". For example, if cell A1 of sheet "Input" is marked "No", I would like to hide rows 26-27 of sheet named "Comparison", if it is marked "Yes" I would like hows 26-27 to be unhidden.

Maybe:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Thank Mumps1 that worked perfectly.

My pleasure.