Hi guys,

I am using the following code to output cell values from excel into word. Many thanks to the thread posters on this forum from which this code was adapted.

Please Login or Register  to view this content.
I would like to know if there is a way of keeping the hyperlinks and formatting from the cells I am copying over please?

I think the problem might be the creation of the 1D variant array (maybe it losses the formatting and hyperlinks) but I don't know of another way that I could use to export an excel table to word via VBA programming.

Thank you in advance for any and all help on this matter.

George