vba to concatenate cells with different font sizes & colour and keep formatting

[cjcass]

Hi,

Wonder if this can be achieved - I need to be able to concatenate 3 cells each with different font attributes (size & colour) and retain the original font attributes of each cell when they have been brought together. Each cell will contain text (1-2 words) and I need to leave a couple of spaces between each cell's contents when they are brought together.

Example;
A5 contains 'Apples' (font size 25, RGB 178,0,0)
B5 contians 'Pears' (font size 12, RGB 50,40,0)
C5 contians 'Lemons' (font size 18, RGB 50,200,40)
The font sizes and colurs are retained in the text string in cell D5 after concatenation.

Any help would be much appreciated.

 

[cjcass]

please ignore this thread - the detail is inaccurate, I will re-submit
(there doesn't seem to be an option on here to delete it!)