Excel Interop Help

[k7s41gx]

Hey All,


I am having an issue returning an entire row of data rather then an individual cell. What am I doing wrong?


For i As Integer = 2 To counta
If CStr(xlWorkSheet2.Cells(i, 21).value) = Form3.Label1.Text Then
t1 = CStr(xlWorkSheet2.Cells(i, xlWorkSheet2.Range(i).EntireRow).Value)
xlWorkSheet2.
Form3.DataGridView1.Rows.Add(t1)
TextBox2.Text = "Row " & i
ProgressBar1.Value = ProgressBar1.Value + 1
Else
ProgressBar1.Value = ProgressBar1.Value + 1
End If
Next


Is there a way to return an entire row of data instead of just a cell?


Thanks!

Continue reading...