How to access contents Excel References (derefencing)

  • Thread starter Thread starter Sam Benson
  • Start date Start date
S

Sam Benson

Here goes...

I understand that the Excel function OFFSET returns a reference (address)
which can be used by functions that accept references.

My question is how can I access the contents of that reference.

I have a defined name that returns a reference to a date. How can I get
Excel to print me the contents of that defined name instead of using it in
a function. I am trying to create dynamic chart titles including the date.

Thanks

Sam
 
Not quite sure what you're asking here, but supposing that you had a date in
cell B24 and you had defined a name for B24 of say MyDate then if you put
=MyDate in any cell, that will show the contents of cell B24.

Is that what you're asking?
 
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

Offset with hlookup as reference 2
Excel Charts 2
Modifying cell references 7
Dynamic named range reference from external workbook 2
Excel Function 2
Graphic but referencing the values range for Y axis in an externalcell (indirect reference) 1
formual to get reference contents 4
Referring To Contents Of Formula 3

Back
Top