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

FAQ

Thread Tools

Display Modes

09-24-2020, 11:17 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

put before end sub

Code:

    With ActiveSheet
    For Each cel In .Range("B2", .Range("B" & .Rows.Count).End(xlUp))
        .Hyperlinks.Add Anchor:=.Cells(cel.Row, cel.Column), Address:=cel.Offset(, 2) & "/" & cel & cel.Offset(, -1)
    Next cel
    End With

« Previous Thread | Next Thread »

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 11:14 AM.