Getting cell number from excel sheet

[Tarik Sheth]

hi,

You can use following code. You can also iterate for all the columns as well

row

Code:

rowCount= DataTable.Getsheet("Global").RowCount
For i = 1 to rowCount
        DataTable.GetSheet("Global").SetCurrentRow i        
        If    DataTable.Value(<Column Name>, "Global") = "Result" Then
                                      MsgBox Found
                          end If

---

You mean cell number.
ok on top of what I have mentioned above you can use the following statement to find the Cell Value.

Code:

cellValue=workSheets("1").range(<your range of columns>.Value

range of the column could be ($P$1) like that.