Creating new Hyperlinks

[rich_drummer]

Hi,

One function of a program that I am writing appends a new hyperlink to the right of the last cell on the 1st row. So, each time the priogram is run, the old hyperlinks should remain and a new one should appear on the right. The issue Im having is that each time I run the code, a new hyperlink is added, but the previous one disappears...

I dont have the code on me, but what I have done is I use the get_range function and get the individual cell, then I use the range.Hyperlinks.Add function to apply the hyperlink to the selected cell.

Does anybody know what I should do to ensure that all old hyperlinks are kept when adding new ones?

Thanks!

Rich

[Leith Ross]

Hello Rich,

Welcome to the Forum!

It is difficult to give you an exact answer without the seeing code. Let's say the last cell in row 1 is Q1 and this cell has the old hyperlink. If you add a hyperlink to cell R1 then the hyperlink in cell Q1 should still be there.

If you add the new hyperlink to cell Q1 then you will lose the old text and the new text will be shown. If you are trying to add more than one hyperlink to the cell then newest added hyperlink is displayed and the previous hyperlink is removed.

[foxguy]

Hi Rich;

I'm guessing that your Get_Range function does something similar to this

Please Login or Register  to view this content.

That gives the macro the column # of the last non empty cell in Row 1.
you probably need to add the line

Please Login or Register  to view this content.

and use lNextCol instead of lLastCol to create the Hyperlink.