Thanks for the reply (and welcome!).
If possible, I would prefer to avoid doing single-cell/mergearea specifications in the code. The form is quite complex, with a not-insignificant number of questions, and a significant number of those have impacts on other questions within the form. I already have too many absolute-references in some of the other code, which makes updating in when additional questions are inserted a real chore. (I realise that seeing the form would probably help explain all this, but I am still waiting on an answer from my employer).
If there is no other way, I will look at switching all of the conditional formatting into the code, but I was really hoping that wouldn't be necessary...




Reply With Quote
Bookmarks