![]() |
Hyperlink problem
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 |
All times are GMT +1. The time now is 09:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com