If you want to preserve the formats already present in the new WB you can use
Selection.PasteSpecial Paste:=xlPasteValues

--
Best wishes,

Jim


"JOUIOUI" wrote:

I'm copying data to a spreadsheet every day with a macro. When the data is
copied to the new WB, it carries over the font formattng and sheet formating
of the original WB. Is there code I can use format a column and font from
row 19458 and forward.