I have a column of cells that I want to put hyperlinks in.
I came up witht the following
I will use a different name each time and the name is the name of the
file in the directory.

newlink1 = "D:/Data/People/Problems/"
fname = "Name1.doc"
Cells(rowctr, 11).Hyperlinks(1).Address = newlink1 + fname

But for some reason, which I have not been able to see, the new
hyperlink will not work.

Can someone help?

Thanks in advance.
xnman