| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
returning a cell name
I have given the cell A1 a name (ie smith). In another cell I am trying to
use the address function to tell me what that cell has been named. If I type in =address(1,1) it returns $a$1. I want it to return smith. Does anyone know how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Cell Comments from One Cell to Another | Excel Worksheet Functions | |||
| Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
| Returning a blank cell rather then #N/A (Lookup) | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| Returning active cell | Excel Worksheet Functions | |||
Threaded Mode
