I am using excel 2013 VBA. I would like to copy the value and formatting (background color) of one range to another range.
The two ranges are identical in size and shape. The code below copies the values, but not the cell formatting. To be specific, I would like to copy the cell value and the background color of the cells in the range.
Also, I do not want the activecell to change. Except for the target, I wish the screen to be unaffected.
Range("Area1").Value = Range("Area2").Value