cell address extraction
 

Demoing from the Immediate window:

Range("A1").Value = 5 ' row
Range("B1").Value = 10 ' column
? Cells(range("A1").Value, Range("B1").Value).Address
$J$5
? Cells(range("A1").Value, Range("B1").Value).Value
Value of J5

a function

=Indirect(Address(A1,B1))

again returns the value held in cell J5. (the text "Value of J5")

--
Regards,
Tom Ogilvy




Dave wrote in message
...
Is there any VBA code or function in Excel 97 that will
return a specific cell address that can be located only
by values in other cells?