Situations that require .PasteSpecial (No args) instead of .Paste

[Oppressed1]

Below is a case where .PasteSpecial works but .Paste does not:

Please Login or Register  to view this content.

1. Does this strike anyone else as odd?

2. I'm a coding junky so I'd like to do this in one step, e.g. range("A1:B1").copy dest:=range("A2:A5").
Setting that aside (see item 3 below), I sure don't want to use THREE lines: (I hope you don't mind the notation change from item 1)

Please Login or Register  to view this content.

YET! this way works without resorting to pastespecial. Why is that? I cringe at the "having to select" - Coding 101 says strive to avoid Selects, right? (Sure, it's going to be selected anyway by virtue of the paste. It still feels aggravating to add the select code line.)

Maybe the bottom line is just that you can .PasteSpecial against ranges but not .Paste, but I'm stubbornly resisting that?

3. range("A1:B1").copy dest:=range("A2:A5")
fails. What am I doing wrong

Bonus questions, aside from this example. You can skip everything past this point.

4. Sometimes in code I'd like to go Selection.Paste, yet it won't execute, but this will:
Activesheet.Paste
I wonder why Activesheet. is required. After all, if I just went Control-V (which this code is intended to duplicate), Excel would know exactly where to post - over the selection! Besides, it would seem that explicitly specifying Selection would theoretically lighten the load on VBA (so he doesn't have to "resolve where to do something" at runtime). (Okay, busted; I realize that Selection itself must be resolved at runtime. Still...)

4A. Since Selection.Paste fails, is Activesheet.Paste the proper or best alternative, or something else?

5. When you have 2 window instances (foo.xls:1 and foo.xls:2 in the window caption) and you go
range("A2:A5").pastespecial
while instance 2 is active, instance 1 also selects A2:A5 (even if it was on row 999). I wish instance 1 would be unaffected. Any perspective on that? (BTW there are some commands that insist on operating on instance 1, such as F5 go to).

TIA

[xlnitwit]

1. The Range object has a PasteSpecial method but not a Paste method. So not odd at all, in spite of your stubborn resistance.
2. A Worksheet does have a Paste method. That method also has a destination argument

Please Login or Register  to view this content.

3. The argument is called Destination not Dest:

Please Login or Register  to view this content.

[Oppressed1]

3 perfectly concise useful answers to 2 useful questions (Let's forget I asked number 3 ). I completely missed the destination arg for activesheet.paste, so you especially saved me there.

Concise and useful. May every answer shine that way +1 Reputation.

I'll just concede that item 5 is "one of those things" to endure.

[xlnitwit]

Thanks.

Re #5, if you can use the one line copy + destination you avoid that issue.

[leelnich]

And since a Range Object doesn't have a Paste method:

Please Login or Register  to view this content.