How to insert from name range into a paragraph?

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

Guest

I am trying to insert a name from a range to a text in excel. I inserted a
name range "Our_Entity" from another tab to the below etxt but ot does not
work.
 
you have to use a formula, I'm guessing LEGAL_LINE_3 is also a name:

="Per agreement between " & Our_Entity & " and " & LEGAL_LINE_3
 
Thanks Esteban

But now my names referenced as dates not working. It reads like this

Company, LLC dated 37681 is requested

but it is formatted as =Company, LLC dated "&Dated_As_Of&"

where Dates_As_of is mapped to 03/05/06 in dated format but it turns into
37681

Thanks
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
Set non-continuous PrintArea via Function / Name 0
Conditional formatting on a dynamic range - workaround 1
Named Ranges and Dynamic Formulas 3
Insert Named Range Into a Cell 2
Totalling Dynamic Range Subtotals in Excel 2003 6
How do I reference a "range" for a specific table_array in VLOOKUP 3
a data validation list that contains a list of named ranges - not alist from a named range 1

Back
Top