How to modify the code to meet the corresponding requirements

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to modify the code to meet the corresponding requirements

09-26-2020, 06:14 AM

NoSparks

Windows 10 How to modify the code to meet the corresponding requirements

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add file name automatically in the vba code ...	LearnerExcel	Excel	3	12-30-2019 06:11 AM
vb code for updating file automatically	klpw	Excel Programming	1	01-14-2016 08:05 PM
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?	commissarmo	Word VBA	3	03-14-2015 12:53 AM
How to convert a text file to an Excel file with the data format automatically?	mradmin	Excel	6	10-16-2013 10:34 AM
How to copy automatically data from Excel file to Word file?	fuchsd	Word	6	10-25-2011 05:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:09 PM.