I'm looking for some help from anyone with some knowledge of the Microsoft.Office.Interop.Excel class.

Specifically, what I am trying to do at the moment is to iterate through a single column range so that I can A.) extract each unique value in that range, and B.) also (in another method) copy all rows with a given value in this range over to another tab.

I guess my main problem is figuring out how to find the last cell of the range, since it is dynamic. And also which sort of loop would be best to use to iterate through that range to pull the data I need.

Hope that made sense, and that someone can shed some light. I'm banging my head over here.