How do I change a cell color to match another cell?

ActiveCell.Interior.Color = Range(“A1”).Interior.Color

Changes the colour of the active cell to A1.

Advertisements