title: Excel VBA get range of user selected range by mouse
body: <p>This is not the <code>usedrange</code> issue.<br>
  For example in Excel user selects a range (possibly empty) using mouse, let's say <strong>B4:C12</strong>  </p>
  
  <p>And let's say after this without deselecting the range user presses the macro, and macro should tell <strong>B4:C12</strong>.  </p>
  
  <p>Can anyone show example?</p>
  
  <p>The macro should be something along the lines of the following:</p>
  
  <pre><code>Sub showrng()
      MsgBox SelectedRange.Address(ReferenceStyle:=xlA1)
  End Sub
  </code></pre>