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.