Hello!

This is my first post, and I'm hoping to get some VBA help for a simple macro I wish to run (I have very little knowledge of macros).

I am creating a new form, and have 2 option boxes. I have linked these checkboxes to a cell which gives a calculation depending on what is selected (cell E10). If the value of this cell is 2, then the person has selected that they don't need to fill in the details below. If this is the case then I would like to hid the entire rows below (rows 18 - 45 to be precise).

At the moment I have used data validation to blank out these rows, but I'd much rather group them automatically to avoid a large gap between the option boxes and the next section. Is there a simple way to do this?

Please let me know if I need to provide more information, or if I need to attach a copy of the spreadsheet (I'm not sure how this works).

Thanks!