title: Get formatted values from a multi-cell range
body: <pre><code>Dim myText As String
  myText= Range("a3").Text
  </code></pre>
  
  <p>Returns the formatted value in cell A3, but </p>
  
  <pre><code>myText= Range("a3:c7").Text
  </code></pre>
  
  <p>gives me an error. </p>
  
  <p>How do I get strings representing formatted values from a multi-cell range, while preserving the number format? i.e. the format of the output text would be the same as if copy-pasting from the range to a text editor.</p>