possible to paste special without having to select?

**timtim89** · 05-21-2012, 07:38 AM

Hey there,

quick question: how to incorperate PasteSpecial into Copy like below?

Please Login or Register  to view this content.

I only have seen the Paste Special with selection property, but I wanna avoid having to select anything.

Thanks

**tom1977** · 05-21-2012, 07:50 AM

Hi look at this

Please Login or Register  to view this content.

add proper worksheet name befor columns(3)

**timtim89** · 05-21-2012, 07:56 AM

Exactly

Thanks! One thing though: is it necessary to put in the CutCopyMode = False? Is it not false by default?

**tom1977** · 05-21-2012, 07:59 AM

Delete this line in the code and everything will be clear

**timtim89** · 05-21-2012, 08:05 AM

I see! Thanks again

Re: possible to paste special without having to select?