VBA Keep hyperlink in a concatenate function

  • Hi everyone,


    I'm trying to add some code in the following Function in order to keep the hyperlinks from the data i concatenated together, but can't figure out how to do it.

    Any tips is much appreaciated.

    Best Benjamin

  • Hi Roy,

    Enclosed is the excel file with VBA


    In the Worksheet MAIN, the table chart called "Output Table" will display concatened values (done already), but does not keep the hyperlink. SOurce table is on the other worksheet called Other.


    What do you think ?

    Ben

    Files