Try Reading your DataTable as an Excelsheet. Try The Below Code to see if it works.
Set objFWorkBook = objExcel.Workbooks.Open ( Excelpath )
Set objnWorkSheet = objFWorkBook.WorkSheets ( sheetname )
set SrchRegion = objnWorkSheet.Range ( "C:C" )
StrVal = "Whatever"
set SrchResult = .Find ( StrVal )
If not SrchResult is nothing then
intRowNo = SrchResult.Row