On the attached workbook, Sheet TED has two columns ( D & F ) with macro-aided combo boxes which return values to columns E & G respectively. When columns E & G are hidden (because they contain values needed by me/the process rather than the user) the values selected in columns D & F overflow into the next unhidden columns ( F & H). When those columns are unhidden I have no overflow problems. How can I prevent overflow into these neighboring columns/cells?
Bookmarks