VBA copying wrong

[aba]

I have a file that has two sheets of data (one continued from the next). I use the following code to copy data from sheet one onto the worksheet:

Range("A1:M65535").Select
Selection.Copy
Windows("PlanView_Data_Extract.xlsm").Activate
Sheets("Q1 & Q2 2011").Select
ActiveSheet.Paste

However, when I copy, it automatically copies data from Sheet 2 (the continuation) onto another sheet on this worksheet. Why does this happen even though a limited range (ie. A1:M65535) is selected?

 

[VoG]

Does this fare any better

Range("A1:M65535").Copy Destination:=Worksheets("PlanView_Data_Extract.xlsm").Sheets("Q1 & Q2 2011").Range("A1")

 

[aba]

Typed like this:

Range("A1:M65535").Copy Destination:=Worksheets("PlanView_Data_Extract.xlsm").Sheets("Q1 & Q2 2011").Range("A2")

The code gives an error:
"Subscript out of range"

 

[VoG]

Either the workbook or the sheet does not exist. Check the spelling.

 

[aba]

Thanks alot!

That worked great! The problem was that I was trying to access a workbook not worksheet so the code was:

Range("A1:M65535").Copy Destination:=Workbooks("PlanView_Data_Extract.xlsm").Worksheets("Q1 & Q2 2011").Range("A2")

Just for my understanding (i'm new to vba) why did the original code not work?

 

[VoG]

You were trying to access a non existing object.