How to get Column & Row Number of specific text in Excel

[AbhijitPatil]

Hi

In excel I need to search for any value.

It should give me the exact cell number where that value is present.

like A5 ,B10...

*(Currently consider unique value, if you have solution when value present in many cells then it is more than better.)*

How to get that cell numbers?

Thanks,
Abhijit

------------------------------
Abhijit Patil
------------------------------

[ewilson]

Hi @Abhijit Patil,

The MS Excel VBO, available on the DX, includes an action called Find in Worksheet. You can specify various input properties including direction of the search, the starting cell, the overall search range, whether to match case, etc.

It will return a Collection containing the cell information of any matches.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------