title: VBA Finding corners of a selection
body: <p>Given a rectangular <code>Selection</code>, how do I find the <code>Cell</code>s for each corner? Specifically, the top right and bottom left.</p>
  
  <p>E.g. if a user selects the range <code>B2:G9</code>, I would like to get the address of each corner from the <code>Selection</code> object. </p>
  
  <p><a href="https://i.stack.imgur.com/xHjCC.png" rel="noreferrer"><img src="https://i.stack.imgur.com/xHjCC.png" alt="Selection corners"></a></p>
  
  <p>I used <code>.Address</code> to get the top left and the bottom right corners, and while I could start splitting the strings and perform regex replace on them I want to know if there is a cleaner way.</p>