View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
oercim oercim is offline
external usenet poster
 
Posts: 51
Default pasting copied cells

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.