Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Name Box cell reference
Want to use the Name Box cell reference (current cell) in a formula. I want
to have a "dynamic cell" that contains data pertinent to the current cell loacation. How do i access the Subject data? |
#2
|
|||
|
|||
Hi
not really sure what you're trying to achive. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany HoJo wrote: Want to use the Name Box cell reference (current cell) in a formula. I want to have a "dynamic cell" that contains data pertinent to the current cell loacation. How do i access the Subject data? |
#3
|
|||
|
|||
=Cell("address")
however to be able to use that in a formula you would ned to wrap it in INDIRECT and as soon as you do that you will get a Circular reference error message. regards, Peo Sjoblom "HoJo" wrote: Want to use the Name Box cell reference (current cell) in a formula. I want to have a "dynamic cell" that contains data pertinent to the current cell loacation. How do i access the Subject data? |
#4
|
|||
|
|||
"HoJo" wrote...
Want to use the Name Box cell reference (current cell) in a formula. I want to have a "dynamic cell" that contains data pertinent to the current cell loacation. How do i access the Subject data? CELL("Contents") returns the value of the active cell. If the active cell contains a formula that contains this function call, then you'll ger a circular reference error. Reply With Quote |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |