If you debug your code you will find that
Obj1
contains
all of the values in your range, not just a single cell.
I also prefer to use the StringBuilder class rather than concatenating strings (you will need
Imports System.Text
)
So potentially the easiest way to iterate through all of the cells would be
Dim sb As StringBuilder = New StringBuilder("")
For Each c As Excel.Range In myRange.Cells
sb.Append(c.Value2)
sb.Append(Environment.NewLine)
Next
displayLabel.Text = sb.ToString()
Note this also works if your range spans across multiple columns e.g. if you had
myRange = xlSheet.Range("A2:B6")
you would get the values from
A2
B2
A3
B3 etc