Hi, in the below code if possible I would kike to have the source font color / style, such as red or bold" remain when being copied from sheet "master" to sheet "new invent". Thanks for the help.
VBA Code:
Worksheets("MASTER").Activate
Range("A1:H1000").Copy Destination:=Sheets("NEW INVENT").Range("A1")
Range("A1:H1000").Copy
Sheets("NEW INVENT").Range("A1").PasteSpecial Paste:=xlPasteValuesAndNumberFormats, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Last edited by a moderator: