P
Paul
Hi,
I have this macro so far (which works)...
nrow = 6
ncol = 1
With Worksheets("Sheet1")
For rwindex = nrow To 22
fname = CStr(Cells(rwindex, ncol).Value)
ActiveSheet.Hyperlinks.Add Anchor:=Cells(rwindex, ncol), Address:= _
"Documents\" + fname + ".pdf"
nrow = nrow + 1
Next rwindex
End With
End Sub
I have a list of files starting in column 1, row 6 and this macro will
search the contents of this cell and input a hyperlink with the cell contents
(with the folder structure implemented) So my hyperlink will show this -
Documents/blababal.pdf Which is what i want, however, I cannot get this to
then start looking through other cells in the worksheet and returning the
value shown above. As i have file lists all over the worksheet. Also i will
need it to not return anything if the cell is blank or has no filename. I
understand this could be difficult (i maybe wrong, but i am new to VBA)
Any help is much appreciated
I have this macro so far (which works)...
nrow = 6
ncol = 1
With Worksheets("Sheet1")
For rwindex = nrow To 22
fname = CStr(Cells(rwindex, ncol).Value)
ActiveSheet.Hyperlinks.Add Anchor:=Cells(rwindex, ncol), Address:= _
"Documents\" + fname + ".pdf"
nrow = nrow + 1
Next rwindex
End With
End Sub
I have a list of files starting in column 1, row 6 and this macro will
search the contents of this cell and input a hyperlink with the cell contents
(with the folder structure implemented) So my hyperlink will show this -
Documents/blababal.pdf Which is what i want, however, I cannot get this to
then start looking through other cells in the worksheet and returning the
value shown above. As i have file lists all over the worksheet. Also i will
need it to not return anything if the cell is blank or has no filename. I
understand this could be difficult (i maybe wrong, but i am new to VBA)
Any help is much appreciated