=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?