Invoke VBA code to find a text

[WS_Chai]

Hello there,

Would like to ask how to write an invoke VBA code which I can look for a text, say “ABC123” in every sheet of an excel file and return the cell address to me if the text is found anywhere?

Thank you in advance!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @WS_Chai ,
I think find text we can use activity
we can read all file to get data table, then find string then return address of cell
regards,

[supriya117 (Supriya Allada)]

Hi @WS_Chai

You can use Vlookup activity instead of VBA code.

[Shiva_Nikhil]

@WS_Chai

You can aslo use

Find/replace activity which is a modern activity

Or you can try with

Vlookup activity

Cheers

[lrtetala (Lakshman Reddy)]

Hi @WS_Chai

You can try like this

Hope this helps!!