Hi, anyone know how to copy the colors of different cells in range to another range of cells?
eg how to copy the colors in f3: f6 to range in d3:d6 ?
Thanks in advance!
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
Sub Test()
Range("F3:F6").Copy
With Range("D3:D6")
.PasteSpecial xlPasteFormats
.PasteSpecial xlPasteValues
End With
End Sub
Return to Macros and VBA Questions
Users browsing this forum: Google [Bot] and 227 guests