pasting copied cells

[oercim]

I have a problem excel macro. I want to paste some previously
copied rows into another sheet. Bu not into location "A1" of the sheet,
I want it to paste into A10. I made a code as below.

Sheets("a").Activate
Sheets("a").Rows("A10").Select
ActiveSheet.Paste

But it dosnt work, it pastes the rows to "A1". Why? Thanks a
lot.

 

[Ron de Bruin]

No need to activate
Copy example fton sheets b to a

Sheets("b").Rows("50:52").Copy Sheets("a").Range("A10")

 

[Gazeta]

I have a problem excel macro. I want to paste some previously
copied rows into another sheet. Bu not into location "A1" of the sheet,
I want it to paste into A10. I made a code as below.

Sheets("a").Activate
Sheets("a").Rows("A10").Select
ActiveSheet.Paste

But it dosnt work, it pastes the rows to "A1". Why? Thanks a
lot.

try to change Sheets("a").Rows("A10").Select into
Sheets("a").Range("A10").Select
mcg

 

[Guest]

A better way might be something like

Sheets("b").Range("A100").Copy Sheets("a").Range("A1")

copies cell a100 from sheet b to cell a1 in sheet a...