I have a worksheet where I copy a range. In the range is data that using conditional formatting changes it font color to red or black based on a criteria.
Is it possible to copy the color of the font in the range as well??
This is the code I use to copy the range from one worksheet to the next
'Copy the data needed
Worksheets("SheetCP").Activate
Worksheets("SheetCP").Range("V3:V45").Value = Worksheets("SheetRP").Range("J11:J53").Value
Worksheets("SheetCP").Range("W3:AA45").Value = Worksheets("SheetRP").Range("L11:P53").Value
PLEASE HELP!
Is it possible to copy the color of the font in the range as well??
This is the code I use to copy the range from one worksheet to the next
'Copy the data needed
Worksheets("SheetCP").Activate
Worksheets("SheetCP").Range("V3:V45").Value = Worksheets("SheetRP").Range("J11:J53").Value
Worksheets("SheetCP").Range("W3:AA45").Value = Worksheets("SheetRP").Range("L11:P53").Value
PLEASE HELP!