Excel Find Value macro

[jpunthambaker]

Hi, I'm attempting to build a solution that involves searching for a specific value in a large excel sheet. Would anybody have any advice on how to do this via a macro / code stage? Iterating through lines takes an excessive amount of time. Thanks

[Deep.Shah]

If simple SQL like queries can help you find what you are trying to search in an Excel, try querying with the help of OLEDB Object.

[ArchiveUser]

Try to check my answer here: https://portal.blueprism.com/excel-issue-need-find-cell-value I have posted a code there

[jpunthambaker]

Radoslav, Deep - many many thanks for your replies - much appreciated. Regards