instead of .value, use .address


"scottfoxall" wrote in message
...
I run a macro to find a value/text in a spread sheet. Instead of getting
the
value from that cell, I want the address. Is there code that can do this?