title: VBA: Get selected Range in a Worksheet where the Selection is a Chart
body: <p>I have a Worksheet, with a Chart in it. If I select a range of cells, and then I select the Chart, then in the immediate window of the VBE</p>
  
  <pre><code>? TypeName(Selection)
  ChartArea
  </code></pre>
  
  <p>So I cannot use <code>Selection</code> to get the selected <code>Range</code>, even if it is there (pressing Esc returns to the selected range of cells).</p>
  
  <p>How can I retrieve that <code>Range</code> in VBA?</p>
  
  <p>PS: I suspect the same Q&amp;A applies to other <code>Shape</code>s.</p>