I have a list of files below in my screenshot that I want to hyperlink. They all belong under the same folder. I am very new to VBA so I am struggling with this. They are all hyperlinked but all of the links lead to the last file "Zttach.xlsx". Is it possible to hyperlink all these files that belong to the same folder with just one macro?
VBA Code:
Sub hyper()
Dim cell
For Each cell In Selection
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="C:\Users\risha\Downloads\a_few_little_tests\New folder\" & cell
Next cell
End Sub
Code: