enter image description hereI'm trying to add an extension to all embedded hyperlinks on an Excel worksheet. I recorded a macro by doing one cell at a time but is not efficient. Can someone help me streamline the macro so that it knows to look at all hyperlinks, open, and insert additional information at the end tail of the existing hyperlink.
Sub Macro5()
'
' Macro5 Macro
' test
'
' Keyboard Shortcut: Ctrl+Shift+H
'
Range("H1").Select
ActiveCell.FormulaR1C1 = "?u=76208058&auth=true"
Range("C2").Select
Selection.Hyperlinks(1).Address = _
"https://www.linkedin.com/learning/teaching-techniques-classroom-management?u=76208058&auth=true"
Range("C3").Select
Selection.Hyperlinks(1).Address = _
"https://www.linkedin.com/learning/learning-how-to-increase-learner-engagement?u=76208058&auth=true"
Range("C4").Select
Selection.Hyperlinks(1).Address = _
"https://www.linkedin.com/learning/teaching-with-technology?u=76208058&auth=true"
End Sub