(Solved) – Can someone provide the technical reason why the `Interior.Color` property can’t be assigned from one range to another in Excel VBA?


I’ve seen this link describing using the clipboard to transfer formats (and this is probably what I’ll end up having to do), but I’d like to know the technical reason why values can be assigned by reference and formats can’t.

In other words, why does this work…

Sheets("Sheet2").Range("A1:B10").Value = Sheets("Sheet1").Range("D1:E10").Value

and this fail?…

Sheets("Sheet2").Range("A1:B10").Interior.Color = Sheets("Sheet1").Range("D1:E10").Interior.Color

Leave a Reply

Your email address will not be published. Required fields are marked *