Hyperlink change address

I have an Excel database which has a hyperlink to a related form for each row
of data.
Each link is to a unique file.
Right now the hyperlink is in column J and the file name is in column K.
So the hyperlink column reads =hyperlink(K1,"File info") and so on.
It works nicely but I'm using two columns for a one column job.

I would like to combine the two columns into one, if possible. So that the
hyperlink would include the actual file path and name and not just the column
reference.

I have tried using a replace command and a concatenate command to try to
combine the two columns into one but neither works.

Any ideas?

Hi LDBlanes-

Have filename in one column and in the column next to that put in the row of
final hyperlink. Concatenate filename and row into text below for each row.

ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:="ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="filename", _
TextToDisplay:="filename"

Range("ColumnRow").Select

Copy the concatenated text results to word, add a paragraph/carriage return
to "TextToDisplay:="filename". Then copy it all back to an Excel macro and
run it.

Hope it makes sense.

PB




Range("C19").Select


"LDBlanes" wrote:

> I have an Excel database which has a hyperlink to a related form for each row
> of data.
> Each link is to a unique file.
> Right now the hyperlink is in column J and the file name is in column K.
> So the hyperlink column reads =hyperlink(K1,"File info") and so on.
> It works nicely but I'm using two columns for a one column job.
>
> I would like to combine the two columns into one, if possible. So that the
> hyperlink would include the actual file path and name and not just the column
> reference.
>
> I have tried using a replace command and a concatenate command to try to
> combine the two columns into one but neither works.
>
> Any ideas?