No need to activate
Copy example fton sheets b to a

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"oercim" wrote in message oups.com...
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.