combining many cells in one cells keeping character font and hyperlinks of all cells

Hi,

I would like to combine the content of many cells into one cells only. The problem is the character formatting and the hyperlinks.

I tried different way to achieve that and the only way i found was to make a function that look at the font of each character of each cells and copy the font for each character.

with 2 cells its not so bad but when i get like 10 cells i have to combine the first 2 cells into another, combine the result with the next cells and so on.

The processing is extremly long. Is there any other way i can achieve that ?

Thats the merge function i use. This function combine 2 cells. The rest of the code use this function to combine all the cells i need to combine

Please Login or Register  to view this content.

originaly i was trying to get a cell in a word table and put it in ONE cell in excell. But with copy and paste it puts the result on many cells.

so what i did is copy and paste in a temporary excell sheet and after that copy the content of those cells in one cell.

I tried to ajust the data directly in the clipboard, not working.
the only way i found that work is the way i posted earlier with the mergecell code. But if there is any other way to achieve that that would be much appreciated.

Any thoughts on this yet ?