Vba copy range without formatting Copy Destination:=Sheets("Accepted Template"). Copy Copy:=xlCopyFormats Worksheets ("Sheet1"). See full list on automateexcel. Apr 1, 2014 · Hey, I got the following code, but the problem is that it replaces the formatting of the cells: Sub CopyIndustry1Weights () Sheets ("Tool"). Please note, this only copies the values it does not copy any formatting. Note: The line Application. PasteSpecial Paste:=xlPasteValues Any idea what I have done wrong here. Cells (. Nov 7, 2011 · Hi guys, This might be a simple thing to do. The Second version is almost instant to copy 500 lines, while the first method adds about 5 seconds to the time. ppcwh rbas otr igr azsfaz ikzcum wyimon afeaw wqhh raxikp xqnl svvwx xqvul rsui tamuyv