Hi,

Address / AddressLocal for a Range gives this !

Regards,
Rain

"Rain" wrote:

Hi,

I am writing VBA code to search for a string on a worksheet. I want to
procedure to return / set a global variable to the location at which the
string is found.
How do I get this ?

TIA

Regards,
Rain