Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
> </o
>
I know that it sounds like an old problem but I still haven’t found anything….<o
></o
>
<o
> </o
>
I have four cells in different sheets each having text in different color. I want to concatenate them into 1 cell into a different sheet and retain the original formatting. i.e. the result cell should have <o
></o
>
<o
> </o
>
a(sheet1) + b(sheet2) + c(sheet3) with original colors of a, b & c.<o
></o
>
<o
> </o
>
Each cell has a quite good amount of text with different formats, e.g. the result cell should be<o
></o
>
<o
> </o
>
This is the text of the cell A<o
></o
>
This is the text of the cell B<o
></o
>
This is the text of the cell C<o
></o
>
Is it possible? <o
></o
>
<o
> </o
>
I’m using excel 2003 and I am a beginner in VBA, but I should be able to follow if you can give me some pointers.<o
></o
>
<o
> </o
>
I’ve tried to use this:<o
></o
>
<o
> </o
>
http://www.mrexcel.com/forum/showthread.php?t=265158<o
></o
>
<o
> </o
>
but it doesn’t work when I use the example mentioned above.<o
></o
>
<o
> </o
>
Thanks<o
></o
>
<o
> </o
>
Edair<o
></o
>




<o


I know that it sounds like an old problem but I still haven’t found anything….<o


<o


I have four cells in different sheets each having text in different color. I want to concatenate them into 1 cell into a different sheet and retain the original formatting. i.e. the result cell should have <o


<o


a(sheet1) + b(sheet2) + c(sheet3) with original colors of a, b & c.<o


<o


Each cell has a quite good amount of text with different formats, e.g. the result cell should be<o


<o


This is the text of the cell A<o


This is the text of the cell B<o


This is the text of the cell C<o


Is it possible? <o


<o


I’m using excel 2003 and I am a beginner in VBA, but I should be able to follow if you can give me some pointers.<o


<o


I’ve tried to use this:<o


<o


http://www.mrexcel.com/forum/showthread.php?t=265158<o


<o


but it doesn’t work when I use the example mentioned above.<o


<o


Thanks<o


<o


Edair<o

