Open Hyperlinks Using VBA in Excel (Runtime Error 9)

Open Hyperlinks Using VBA in Excel (Runtime Error 9)

I am trying to use VBA to open hyperlinks from my excel using the
following code:
numRow = 1
Do While WorksheetFunction.IsText(Range("E" & numRow))
ActiveSheet.Range("E" & numRow).Hyperlinks(1).Follow
numRow = numRow + 1
Loop
However, I keep getting Runtime Error 9: Subscript out of range at the
point in the code where I follow the hyperlinks.
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)
Thanks