title: convert external cell address into range in vba
body: <p>I have a string in cell A1, which is the cell address of an external cell (i.e. another workbook), </p>
  
  <pre><code>'[data transfer utility.xlsb]Sheet1'!$B$5
  </code></pre>
  
  <p>In vba I would like to create a range object, <code>myRange</code>, that would correspond to the address stored in cell A1.</p>
  
  <p>I've tried various solutions, but none have worked.</p>