I have inputed certain text into msgbox which is available in certain row of excel table.Now using for each row i am trying to read the respective next column data if condition matches like ‘row(1).ToString=S_Class’
If I use the code of index it give me the row number matching ‘BET.Rows.IndexOf(row)+1’ and if I give Row(3).tostring it give validation error.
Please suggest