Range VBA function have a way to identify cell co-ordinates

Hi,

Sorry, not sure if co-ordinates is the right word. I found:

Range(strCellRange).Value' = say this returns 'hello world'

Is there a way I can find say where hello world exists on the spreadsheet so like:

Range(strCellRange).????' = A1 (the location of hello world).

Cheers,
John

Hi,

The property you are looking for is : Address

In order to code the search, you will need to use : Find

HTH

Originally Posted by JeanRage

Hi,

The property you are looking for is : Address

In order to code the search, you will need to use : Find

HTH

Hi mate,

That worked a treat!!!

All the best,
John