Forum Discussion
Recorded Macro does not capture a click on a web-link (URL)
The cell contained a formula to create the hyper-link and not the actual resultant, this was the key to searching for a solution.
I found an article that showed how to replace the formula in a cell with it's result
And now all works fine when recording a macro with a mouse click on a cell that has a calculated hype-link. I can't believe it was as simple as clicking F2 and then F9 as described here:
https://support.office.com/en-us/article/replace-a-formula-with-its-result-38001951-c0e8-4fbd-9048-37ef81e2891e
And best of all the new cells all copy down the column with variables in tackt and the resultant as intended.
With some help of
https://docs.microsoft.com/en-us/office/vba/api/Excel.Workbook.FollowHyperlink
this seems to work:
Sub FollowHLink()
Dim Hlink As String
Range("A1").Select
Hlink = ActiveCell
ActiveWorkbook.FollowHyperlink Address:=Hlink
End SubYour hyperlink formula was entered in A1. Perhaps you can get it to work now.
The cell contained a formula to create the hyper-link and not the actual resultant, this was the key to searching for a solution.
I found an article that showed how to replace the formula in a cell with it's result
And now all works fine when recording a macro with a mouse click on a cell that has a calculated hype-link. I can't believe it was as simple as clicking F2 and then F9 as described here:
https://support.office.com/en-us/article/replace-a-formula-with-its-result-38001951-c0e8-4fbd-9048-37ef81e2891e
And best of all the new cells all copy down the column with variables in tackt and the resultant as intended.