I am trying to copy a range of cells, rows from one worksheet to another including the formatting and values. The code below is my latest attempt that is getting a subscript error. :( Dim SourceRange As Range Dim DestinationRange As Range Set SourceRange = Worksheets("ws1_ICE").Range("A1:J7") Set DestinationRange = Worksheets("ws2_TCO").Range("A1") SourceRange.Copy DestinationRange DestinationRange.PasteSpecial Paste:=xlPasteFormats DestinationRange.PasteSpecial Paste:=xlPasteValues
Solved by Z. B. in 30 mins