Create Macro using VBE in Excel to high and unhide rows based on a value : I am trying to create a survey in excel and want to hide and unhide rows based on their answers. For example, If D3 = "no" hide rows D4:D10, and I want to repeat this multiple times throughout, but the number of rows to hide changes. So if D3 = "yes" leave unhidden. Then move to answer D5, if D:5 = "no" hide rows D6:D7. And this continues on and on throughout. I am fine writing a macro for each one, but I have not found one that works out there like this. I would appreciate any help I can get. I am not overly familiar with using VBE. 