Excel Ranges with C#.net

E

Ethan Strauss

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top