VBA code to hide/unhide based on drop-down box and tick boxes

[DaveOli]

Hi,

So I have a code that works to hide/unhide columns and/or rows based on a drop down box, and also a code that works the same based on whether a box is ticked. When attempting to combine them together the whole thing seems to fail, as the columns and/or rows that require hiding/unhiding have overlapping ranges in the two codes.

I guess my question is, is there a code to hide/unhide columns and/or rows based on a drop-down box of say 20 options and also 5 tick boxes that may have overlapping ranges?

Thanks in advance!