Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
Extraction | Excel Worksheet Functions | |||
selected extraction of cell ref in a series of cells in a row/colu | Excel Worksheet Functions |