I have 2 worksheets in my workbook. First worksheet has name range (for
example a1:b5 name = valName). In another worksheet I want to create cell
validation as combobox by using value from range name "valName" in first
worksheet as it source. How can I do that in C#?