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: 831

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

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