https://community.blueprism.com/t5/Product-Forum/How-to-get-Column-Row-Number-of-specific-text-in-Excel/m-p/50625#M5825 Hi<BR /><BR /> <P>In excel I need to search for any value.</P> <P>It should give me the exact cell number where that value is present.</P> <P>like A5 ,B10...<BR /><BR />*(Currently consider unique value, if you have solution when value present in many cells then it is more than better.)*<BR /><BR />How to get that cell numbers?<BR /><BR />Thanks,<BR />Abhijit</P><BR /><BR />------------------------------<BR />Abhijit Patil<BR />------------------------------<BR /> Wed, 05 Jan 2022 15:29:00 GMT AbhijitPatil 2022-01-05T15:29:00Z https://community.blueprism.com/t5/Product-Forum/How-to-get-Column-Row-Number-of-specific-text-in-Excel/m-p/50625#M5825 Hi<BR /><BR /> <P>In excel I need to search for any value.</P> <P>It should give me the exact cell number where that value is present.</P> <P>like A5 ,B10...<BR /><BR />*(Currently consider unique value, if you have solution when value present in many cells then it is more than better.)*<BR /><BR />How to get that cell numbers?<BR /><BR />Thanks,<BR />Abhijit</P><BR /><BR />------------------------------<BR />Abhijit Patil<BR />------------------------------<BR /> Wed, 05 Jan 2022 15:29:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-Column-Row-Number-of-specific-text-in-Excel/m-p/50625#M5825 AbhijitPatil 2022-01-05T15:29:00Z https://community.blueprism.com/t5/Product-Forum/How-to-get-Column-Row-Number-of-specific-text-in-Excel/m-p/50626#M5826 Hi <A class="user-content-mention" data-sign="@" data-contactkey="fa949012-9e8c-4b1d-be4d-fa56a89ad53f" data-tag-text="@Abhijit Patil" href="https://community.blueprism.com/network/profile?UserKey=fa949012-9e8c-4b1d-be4d-fa56a89ad53f" data-itemmentionkey="a9b22dc5-5ade-4c3d-8555-b63af2415659">@Abhijit Patil</A>,<BR /><BR />The MS Excel VBO, available on the DX, includes an action called <STRONG>Find in Worksheet</STRONG>. You can specify various input properties including direction of the search, the starting cell, the overall search range, whether to match case, etc.<BR /><BR />It will return a Collection containing the cell information of any matches.<BR /><BR /><A href="https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo" target="_blank" rel="noopener">https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo</A><BR /><BR />Cheers,<BR />​<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Integrations and Enablement<BR />Blue Prism Digital Exchange<BR />------------------------------<BR /> Wed, 05 Jan 2022 15:47:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-get-Column-Row-Number-of-specific-text-in-Excel/m-p/50626#M5826 ewilson 2022-01-05T15:47:00Z