Hello,
can someone help me with rule what cell values from exel?
I have table in excel lets say:
A B C ....
1 "m" "1" "x"...
2 "m" "2" "t"....
3 "y" "1" "t"....
4 "y" "2" "x"....
I want to find row number where: A="m" and B="2"
I find out how to get row number where just A="m".
aRow = GoExcel.CellValues(Worksheet, Sheetno, "E2", RowEnd)
For Each Row As String In aRow
x = Row
If x = main_diameter Then
MessageBox.Show(x)
End If
Next
Thank you.
