Vb Net Excel Com Question

[melegant]

Trying to do some Cell manipulation/checking..

I have tried a number of things to determine a value of a cell and none work, all throw me an exception about range not equalling string...
so I assume I must select the cell, then test for its value BUT..
anytime I type
MyExcel.Cells(1,2)
the next dot after cells only gives me gettype, and no other option from the excel object
now, i am new to NET..so perhaps this is one of it's things.. I am not sure..here is an example block of code
I demonstrate the diff things I have tried..

Dim Myexcel as New Excel.Application()
Dim A As Integer

Do Until A = 669
Do Until tmp <> " "

If myexcel.Cells(A,2).Text = " " Then
B = B + 1
Else
tmp = myexcel.Cells.Item(B, 2)
End If
Loop
If myexcel.Cells.Item(A, 5) = " " Then
A = A + 1
Else

End If

Loop

[melegant]

I have discovered what works.

If myexcel.Cells(A,2).Text = " " Then

Seems to do the trick!