Member Avatar for ctsmith84

I've been googling, and googling this topic, but can't seem to find an answer.

I'm using the Microsoft.Office.Interop for Excel (and using C#). I have a worksheet that has a table with 7 columns, and a dynamic number of rows. I cannot for the life of me figure out how to loop through the range of rows.

What I need to be able to do is loop through the range, checking the first cell of the row for a name. And then I need to copy that entire row over to another worksheet.

Does anyone know how to loop through a Range, and more specifically, check the value of only the first cell in that row?

any help would be GREATLY appreciated.

Edited by ctsmith84 because: n/a
  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 14 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.