Hi,

I am trying to get a single row; row 20, to either hide or unhide depending on what is selected from a drop down menu. The drop down menu is located in a merged cell; P10:R10. The drop down menu only has two options; "Horizontal" or "Vertical". I want to get row 20 to hide when "Horizontal" is selected and then to unhide when "Vertical" is selected.

I have been trying all day with various macros and formulas out there but with no luck . My knowledge of VB is basic.

Thanks