i have created a macro with which, a range of cells are copied and pasted into a new generated workbook. however, the cells are copied without any color, even though in my original file there was color white. i guess i need to paste in special.... here my macro:
Range("a:f").Select Selection.Copy Workbooks.Add ActiveSheet.Paste
LMsg = "Copy has completed."
LMsg = LMsg & Chr(10) & "You can view the new workbooks under the Windows menu." MsgBox LMsg
It's odd as I would EXPECT that a paste would be a full paste generally, certainly by doing it manually that is what I get,but including
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
before your Lmsg line should give you the result you need.