yeah, there is no way to 'hide' a range that doesn't include full row or full columns (not even sure what that would look like except in the sense or them being a white block, which is what conditional formatting would produce).
So a macro could do the essentially same thing making those range(s) white out, but conditional formatting would be much easier. I'm not sure what your complex formulas have to do with it but if you don't want to use conditional formatting, and those ranges are formulas or constants, you could also simply add an if statement to check for the checkbox state and either display the value or ""