Search a word in a worksheet and store the location

[benjamin132]

Hello everyone, I need to create a macro to find in a worksheet the location of every cells which contains "ETH" ( the location can change) and store each in a variables in order to use it after that . Like the picture below. Thanks guys :D

 

[kokano90]

What is the desired result?

 

[benjamin132]

know the location of these cells for example in my picture, store D14 in a variable and D15 in an other one thanks to a loop

 

[kokano90]

know the location of these cells for example in my picture, store D14 in a variable and D15 in an other one thanks to a loop

I wonder if it will display a message after searching

 

[benjamin132]

no just store the information in a variable inside my macro