title: Name and values: single cells vs. range
body: <p>I have a problem using named range in Excel.</p>
  
  <p>If I create a named range using a cell range, I can obtain also a value.</p>
  
  <p>If I select the same cell, one by one using mouse, I haven't anymore an associated value.</p>
  
  <p><a href="https://i.stack.imgur.com/BIlEg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BIlEg.png" alt="As you can see, I have &quot;{...}&quot; as value for all the range select one by one and not using a range"></a></p>
  
  <p>I have tried also to use VBA, and the result is the same.</p>
  
  <p>Have you some idea to obtain values using multiple cells (without using single range)?</p>
  
  <p>Result expected:
  I'm expect to see cell values of the single cells.
  - As you can see, if I choose every single cell (A2,A3,A4), Excel doesn't display me the value of these cells inside the name box.
  - If I choose a single range (A2:A4), I can see the value of these cells.</p>
  
  <p>How can I display the value of these cells inside Name instead of {...}</p>
  
  <p><a href="https://i.stack.imgur.com/EtIzc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EtIzc.png" alt="enter image description here"></a></p>