Sub TAKEDATA()
With Sheets("F")
FULRNG = .Range("A" & Rows.Count).End(xlUp).Row
Range("A2:A" & FULRNG).Copy SHEET("RESULT").RANGE("B11").PasteSpecial
Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End With
End Sub

I want to copy but I want copied data to be pastespecial on
destination cell. I have tried above code but I am getting error. I
want to do it by using "With Sheets("F")" statement. Is there way I
can copy the way I am doing in above code but data should be
pastespecial. any help will be very useful. Thanks