Microsoft Office Forums - View Single Post - [Solved] Make hyperlink in macro using Clipboard

Thread: [Solved] Make hyperlink in macro using Clipboard

View Single Post

Old

11-05-2022, 05:15 AM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2019

gmayor uses Office 2019

Office 2019

Expert

Join Date: Aug 2014

Posts: 4,138

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

Put the cursor in the first line of the link text and run the following to hyperlink that text.

Code:

Sub Macro1()
Dim oRng As Range
Dim sLink As String
    Selection.HomeKey
    Set oRng = Selection.Range
    oRng.MoveEndUntil Chr(11)
    sLink = oRng.Text
    oRng.Hyperlinks.Add oRng, sLink
End Sub

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote