Name Box cell reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
not really sure what you're trying to achive. Could you give an example?
 
=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 said:
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?
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Dynamic Named Ranges 3
Can I use a worksheet name in a formula? 4
Question on Named range with formula 2
Multiple Criteria, One Answer 1
Reference the same cell based on tab name 1
Referencing External files with slightly different names 4
Creating a high performance dynamic name 2

Back
Top