Hello,
I am trying to make a list of files in excel. each cell needs to have a hyperlink, so when I click on the cell content it opens the file.
With excel 2003 I used this code:
With ActiveSheet
i = 0
For Each rngCell In .Range("A1:A65530")
i = i + 1
A$ = Cells(i, 2).Value + Cells(i...