If I read you corectly, you want to copy C4:C lastrow to somewhere...

With Sheet1
.Range("C4:C" & .[c65536].End(3).row).copy Destination:= Sheet2.Range("A1")
End with

will copy the desired range to sheet2...

Martin