The contents are getting pasted into Column A instead of the newly inserted column or I am getting an error message. Any input is appreciated. Maybe I am making a mistake.

In this code, I have the data going into Column A.

Option Explicit

Sub FindColumn()
Dim NC As Long
NC = Sheets("Count").Range("A1").End(xlToRight).Row

   Sheets("Number").Range("E4:E20").Copy
   Sheets("Count").Cells(4, NC).PasteSpecial xlPasteValues
   
End Sub
In the code below, I am getting an error message and this line of code is being highlighted. Sheets("Total").Range("A1").End(xlToRight).Offset(3, 1).PasteSpecial (xlPasteValues)

Sub FindColumn()
   Sheets("Number").Range("E4:E20").Copy
   Sheets("Count").Range("A1").End(xlToRight).Offset(3, 1).PasteSpecial (xlPasteValues)
End Sub

Sorry if its my fault. Thanks for your help.