Hi,
I am making some Excel 2007 templates using C#.net and I have a couple of
questions.
If I have a named ranged (I set this using "sheet.get_Range(Cell1,
Cell2).Name = rangeName;", how can I get that range again using just the
name? I would really like to do something like
Range newRange = sheet.get_Range(RangeName);
but can find nothing like that. Is that possible?

Also, is there a way to defined a named range with discontinuos cells? Excel
will allow me to make a Name which is assigned to arbitrarily selected cells,
but I can't find a way to do it in code.

Thanks!
Ethan