title: Open Hyperlinks Using VBA in Excel (Runtime Error 9)
body: <p>I am trying to use VBA to open hyperlinks from my excel using the following code:</p>
  
  <pre><code>numRow = 1
  Do While WorksheetFunction.IsText(Range("E" &amp; numRow))
      ActiveSheet.Range("E" &amp; numRow).Hyperlinks(1).Follow
      numRow = numRow + 1
  Loop
  </code></pre>
  
  <p>However, I keep getting <code>Runtime Error 9: Subscript out of range</code> at the point in the code where I follow the hyperlinks. </p>
  
  <p>I'm pretty new to VBA Macro-making (as in-'never done it before'), so help would be appreciated. (And if there's a better way to open a link from each cell in a single column, I'd appreciate learning about that too)</p>
  
  <p>EDIT (To add more Info)</p>
  
  <p>The hyperlink in question has been created using HYPERLINK Worksheet function and the text does not display the link URL. Sample of worksheet data is something like this:</p>
  
  <p>What It Looks Like                 </p>
  
  <p><strong>Case</strong> ------ <strong>Link</strong><br>
  Case1----- Summary<br>
  Case2----- Summary<br>
  Case3----- Summary         </p>
  
  <p>The Cells showing the text "Summary", however, contain a formula          </p>
  
  <pre><code>=HYPERLINK("whateverthebaseurlis/"&amp;[@[Case]]&amp;"/Summary", "Summary")
  </code></pre>
  
  <p>And this is the link that has to be followed. The link works, it can be followed manually. But I need to do it via macro</p>
  
  <p>Thanks</p>