VBA Copy/Paste Formatting

[Chris Macro]

I am getting an error on this line of code and I assume that it is just formatted wrong. I also put in the next line for pasting as I believe it might be formatted incorrectly also. The error I am getting is "Method 'Range' of 'object_Worksheet' failed".

Variable LastRow_T1 = 16

Code:

****sheet2.Range(Cells(14, "C"), Cells(LastRow_T1, "N")).Copy
****Sheet5.Range("A5").Paste

 

[Chris Macro]

Here is my solution:

<font face=Calibri><SPAN style="color:#007F00">'Paste Table 1</SPAN><br>    Sheet5.Rows("6:" & InsertNumber).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove<br>    <br>    sheet2.Range("C14:N" & LastRow_T1).Copy<br>    Sheet5.Range("A5").PasteSpecial Paste:=xlPasteValues</FONT>