https://community.blueprism.com/t5/Product-Forum/How-i-select-today-date-from-excel-without-using-for-loop/m-p/66019#M18624 You can find cell containing today date (you'll have to create your own action for it) , then read just that column to collection. My code for Sheet.Find below. What - String to find, After - cell address to start search from, xlWhole - 1 to find exact patch, 2 - partial; returns address Dim ws as Object = GetWorksheet(handle,workbookname,worksheetname,False) address = """" sheetexists = ws IsNot Nothing If sheetexists Then      address = ws.UsedRange.Find(What,ws.Range(After),Type.Missing,xlWhole).Address() End If Fri, 26 Oct 2018 18:40:00 GMT AndreyKudinov 2018-10-26T18:40:00Z https://community.blueprism.com/t5/Product-Forum/How-i-select-today-date-from-excel-without-using-for-loop/m-p/66018#M18623 I had attached an excel. I had to highlight today date from excel file. Fri, 26 Oct 2018 15:38:00 GMT https://community.blueprism.com/t5/Product-Forum/How-i-select-today-date-from-excel-without-using-for-loop/m-p/66018#M18623 PuneetSingh 2018-10-26T15:38:00Z https://community.blueprism.com/t5/Product-Forum/How-i-select-today-date-from-excel-without-using-for-loop/m-p/66019#M18624 You can find cell containing today date (you'll have to create your own action for it) , then read just that column to collection. My code for Sheet.Find below. What - String to find, After - cell address to start search from, xlWhole - 1 to find exact patch, 2 - partial; returns address Dim ws as Object = GetWorksheet(handle,workbookname,worksheetname,False) address = """" sheetexists = ws IsNot Nothing If sheetexists Then      address = ws.UsedRange.Find(What,ws.Range(After),Type.Missing,xlWhole).Address() End If Fri, 26 Oct 2018 18:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-i-select-today-date-from-excel-without-using-for-loop/m-p/66019#M18624 AndreyKudinov 2018-10-26T18:40:00Z