Hi Roderick,
It works fine for me. I put together a sample. Please take a look at this sample and again if you see the same problem please specify the formattings which you used in those ranges.
Range_8888.zip
Best Regards,
Seetha.
>Hi! When i set value to Range, this Range lose his formatting. i.e.
>
>range.Value = "Hi"; // Erase the privious formatting