Uzytkownik "oercim" napisal w wiadomosci
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.


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