> rngTest(x, y).Interior.Color = interiorTemp.Color
>
> etc.

I'm affraid that is the only way, except hacking with CopyMem, I suppose...

>
> Note that this will not help with the formatting of the cell contents
> (Bold, Font, Color/ColorIndex, etc.).

Didn''t get that far yet, but I'll keep an eye on it.

Vasant, is there a reason known to mankind that you know of why these things
are not working in both directions?

Ava.

>
> --
>
> Vasant
>
>
> "Ava" <dontspam@comeon> wrote in message
> news:%23XfNSk5oFHA.1444@TK2MSFTNGP10.phx.gbl...
>> For a special project I need to be able to copy the contents of one cell
>> to another *including* all formatting. Sometimes I cannot help but to
>> overwrite a cell I need later on. The tricky part comes when I have to
>> recall the lost formatting of that overwritten cell. I basically don't
>> have, or want, permission to rework any sheets that this little 'machine'
>> is going to be attached to, nor do I want to put such a burden on its
>> users.
>>
>> For instance, I can get .Interior and put it in an object variable like
>> this:
>>
>> Dim interiorTemp as Interior
>>
>> Set interiorTemp = rngTest(x, y).Interior
>>
>> Now interiorTemp has all parameters for font, pattern and their color.
>> Nifty. But I cannot find *any* simple way to do the reverse:
>>
>> Set rngTest(x, y).Interior = interiorTemp (Error 13, types don't
>> match)
>>
>> The help in my version of Excel doesn't specify this but someone pointed
>> out to me these objects are read-only. I find that unbelievable, but fact
>> is, I cannot restore.
>>
>> Some forum members (not this forum) told me to swap the styles. But the
>> cells could have any additional formatting that is not stored in a Style.
>>
>> I could write a lot of code and restore the members of the saved objects
>> one-by-one. If I didn't have to swap I could use rngsource.Copy
>> rngdestination, which seems to do everything I need, until I need to swap
>> contents of two cells.
>>
>> So, the simple question is: How do I put saved formatting into a cell? Is
>> it possible?
>>
>> Ava.
>>
>
>