I've got numerous hyperlinks in a row. I would like to select some of them, say 10, and then run a macro that will follow each of them opening 10 windows to each URL. I'm trying to use the following macro:

Sub followLink()
'
' Keyboard Shortcut: Ctrl+f
'
On Error Resume Next
For Each Cell In Selection
Cell.Hyperlink.Follow
' I also tried Cell.Hyperlinks(1).Follow, but this also does nothing
Next Cell
On Error GoTo 0
End Sub

I don't get an error, however no browser windows open. If I click on individual hyperlinks a browser window opens as expected.

Can anyone help me figure out how follow muliple links with a single click?