https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49365#M4784 Hi, Easiest way is to use MS Excel VBO . Thu, 23 Jun 2016 12:55:00 GMT MurthujaShaik 2016-06-23T12:55:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49364#M4783 I have an excel file pulled into a collection. I now need to identify a cell location that contains specific text. Should I use Business Object Utility Calculation Manipulation or MS VBO Excel to find the exact cell? Wed, 22 Jun 2016 20:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49364#M4783 john_shiels 2016-06-22T20:27:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49365#M4784 Hi, Easiest way is to use MS Excel VBO . Thu, 23 Jun 2016 12:55:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49365#M4784 MurthujaShaik 2016-06-23T12:55:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49366#M4785 Is there any resolution on this topic? Using the Excel VBO is best when working with small worksheets. When the line count >1000, it would be nice to use a macro to find a cell with a specific value & then use the 'get active cell' VBO action. Any insight or assistance on creating such a code stage would be very helpful. Thanks. Tue, 28 Jun 2016 03:41:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49366#M4785 jpunthambaker 2016-06-28T03:41:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49367#M4786 You may use the following solution and add a code stage into MS Excel VBO Inputs: [handle] as number, [Workbook], [Worksheet], [Range], [Value] - all as text Outputs: [CellRef], [Message] - both as text Code: Dim excel, sheet As Object Try sheet = GetWorksheet(Handle, Workbook, Worksheet) excel = sheet.Application If sRange="""" Then Message = ""No Range provided"" Else sheet.Activate sheet.Range(sRange).Find(What:=FindValue, LookIn:= _ -4163, LookAt:=1, SearchOrder:=1, SearchDirection:= _ 1, MatchCase:=False, SearchFormat:=False).Activate CellRef = excel.ActiveCell.Address End If Catch e As Exception Message = e.Message Finally excel = Nothing sheet = Nothing End Try Tue, 28 Jun 2016 13:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49367#M4786 ArchiveUser 2016-06-28T13:27:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49368#M4787 Hi Radoslav, The code works wonderfully although there were two very slight syntax errors. Fixed version is below. Namely, I changed all instances of sRange to Range & changed FindValue to Value. Cheers. Inputs: [handle] as number, [Workbook], [Worksheet], [Range], [Value] - all as text Outputs: [CellRef], [Message] - both as text Code: Dim excel, sheet As Object Try sheet = GetWorksheet(Handle, Workbook, Worksheet) excel = sheet.Application If Range="""" Then Message = ""No Range provided"" Else sheet.Activate sheet.Range(Range).Find(What:=Value, LookIn:= _ -4163, LookAt:=1, SearchOrder:=1, SearchDirection:= _ 1, MatchCase:=False, SearchFormat:=False).Activate CellRef = excel.ActiveCell.Address End If Catch e As Exception Message = e.Message Finally excel = Nothing sheet = Nothing End Try Tue, 28 Jun 2016 20:15:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49368#M4787 jpunthambaker 2016-06-28T20:15:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49369#M4788 Thank you for fixing. The problem was that the data item name differed from the variable name in the code which I did not notice when posting. Wed, 29 Jun 2016 12:13:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49369#M4788 ArchiveUser 2016-06-29T12:13:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49370#M4789 No problem! Thanks for your help. Just wanted to note something to future viewers of this thread. The code above attempts to find items with 'Match entire cell contents' enabled. The use of the wildcard * negates this. -Jay Wed, 29 Jun 2016 19:18:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49370#M4789 jpunthambaker 2016-06-29T19:18:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49371#M4790 Thank you for the code, I'm trying to use this code but I have the following message in the data item [Message]: ""Object variable or With block variable not set."" Do you have any idea on how to resolve this ? Thank you. MBarrak Wed, 23 Aug 2017 14:36:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Issue-Need-to-find-cell-value/m-p/49371#M4790 MahmudBarrak 2017-08-23T14:36:00Z