This project has moved. For the latest updates, please go here.

Is there an Equivalent to ExcelApplication.Intersect method.

Mar 1, 2012 at 10:06 PM

This is the first I am using this library so I apologize if this is obvious.

I am replacing an Excel automation solution using this library. There are several places where I used to do an Insersect method. I have named ranges in Excel that name the columns for a group of rows. I used to call the Intersect passing in two named ranges (column and a second range that was the row). This ould get me to the specific column for a given row. Is there anything close to that or am I left to enumerating and looping?

Thanks in advance.