Paste Values in Specific Location

[Eric G]

This works:

ws.Range("N1").Select

ActiveSheet.PasteSpecial Format:="Unicode Text", Link:=False, _
        DisplayAsIcon:=False, NoHTMLFormatting:=True

This does not:

ws.Range("N1").PasteSpecial Format:="Unicode Text", Link:=False, _
        DisplayAsIcon:=False, NoHTMLFormatting:=True

How do I make the second one work? I want to avoid selecting a cell. Thanks.

 

[Learn Excel in Tamil]

Hi Eric,

Please specify you need to copy from Range("N1") and paste into the some other place without using cell range,
if yes, how you identify where the copied value should be pasted ?