Excell - VBA copying from one worksheet to other 1

[Evening]

I have 2 worksheets in the workbook:
1) sheet-1
2) sheet-2

I am using VBA to do some processes in workbook.
I am in sheet-2, want to copy data to sheet-1.

Sheets("sheet-2").Range("A12:M1000").Copy
Sheets("sheet-1").Range("A10").Select ----> Run time error
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False'

Sheets("sheet-2").Range("A1").Select

I am getting runtime error 9.

 

[SkipVought]

Hi,

You don't need to select. in fact it slows down your program.

Sheets("sheet-2").Range("A12:M1000").Copy
Sheets("sheet-1").Range("A10").PasteSpecial _
  Paste:=xlPasteValues, Operation:=xlNone, _
  SkipBlanks:=False, Transpose:=False

with Sheets("sheet-2")
   .Activate
   .Range("A1").Select
End with

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[Evening]

Thanks Skip, your help fixed my trouble, it works...