Is use of "Destination:=" is safe for pasting data

[ThrottleWorks]

Hi,

I am using below mentioned code to paste data.
I noticed use of "Destination:=" while browsing some excel related search on internet.

Would like to know is it safe to use "Destination:=" for pasting data.
Till now I have not faced any issues while using this line just wanted to know out of curiosity.

Can anyone please help me in this.

Rng.Copy Destination:=Worksheets("AAA").Cells(1, 36)

 

[Deepak]

It's safe!!

Other's method like as

Sheets("Sheet2").Range(Target.Address) = Sheets("Sheet2").Range(Target.Address)

or paste special also would be used depend on the situation.

 

[ThrottleWorks]

Hi @Deepak Sir, thanks for the help. Now I can use this feature without worry.

 

[Somendra Misra]

Hi Sachin,

I also regularly use it, but you can drop Destination:= from the statement and directly use like:

rng.copy Worksheets("AAA").Cells(1, 36)

Regards,

 

[ThrottleWorks]

Hi @Somendra Misra Sir, thanks for the help.

Have a nice day ahead.