Microsoft Office Forums - View Single Post - [Solved] How to modify the code to meet the corresponding requirements

Thread: [Solved] How to modify the code to meet the corresponding requirements

View Single Post

Old

09-26-2020, 06:14 AM

NoSparks

NoSparks is offline

NoSparks uses Windows 10

Windows 10 NoSparks uses Office 2010

NoSparks uses Office 2010

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

NoSparks is a glorious beacon of light

NoSparks is a glorious beacon of light

NoSparks is a glorious beacon of light

NoSparks is a glorious beacon of light

NoSparks is a glorious beacon of light

Default

Oops, forgot to adjust the build of the hyperlinks after altering column D to be the full path, just needs to be

Code:

    .Hyperlinks.Add Anchor:=.Cells(cel.Row, cel.Column), Address:=cel.Offset(, 2)

Reply With Quote