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.