"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