Member Avatar for ctsmith84

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.

Corey

  • 2 Contributors
  • 1 Reply
  • 89 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by sandeepparekh9
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.