I have 2 sheets in my file. I want to copy the font color in Sheet (MonNTM) to Sheet (Mon).
I have tried this code but nothing happens.
Sub setColorCity()
Worksheets("Mon").Range("b12:aa19").Font.Color = Worksheets("MonNTM").Range("b12:aa19").Font.Color
End Sub
I would appreciate any suggestions.
Tks.
I have tried this code but nothing happens.
Sub setColorCity()
Worksheets("Mon").Range("b12:aa19").Font.Color = Worksheets("MonNTM").Range("b12:aa19").Font.Color
End Sub
I would appreciate any suggestions.
Tks.
Last edited: