title: insert a hyperlink into excel 2007 using VBA
body: <p>My worksheet "input" range "<code>B11</code>" has generated the destination URL:</p>
  
  <pre><code>file:///C:/Results/H1230-01%20VEF%201288.doc
  </code></pre>
  
  <p>My worksheet "input" range "<code>B10</code>" has generated the text:</p>
  
  <pre><code>H1230-01 VEF 1288
  </code></pre>
  
  <p>How can I automatically insert the hyperlink of the destination URL with the displayed text in a cell?:</p>
  
  <pre><code>Worksheets("VEF").Range("m65536").End(xlUp).Offset(1, 0).Select
  </code></pre>