Binding variables

[Luis939]

I hope its possible, but basically ill have an array of about 5 different strings. I want to use .find method ONCE to find what cell they are in, in my worksheet. How do I bind that cell address to the string whenever that string comes up again, so I wont use the .find method again. I can record the different cell addresses in individual variables, but i dont to use a big Case statment saying trying to link the strings to the addresses...thanks!

 

[PHV]

You may consider to use a Collection object as an associative array: myCollection(keystring) -> cell.address

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Luis939]

i'm a little unclear as to the solution, but i am interested, perhaps you can help me out a little bit more, thank you