moves data from one excel sheet to another

Hey guys
I'm a newbie to the VBA/Excel applications environment and I am having a heck of a time trying to understand and work thru what seems to be a simple copy example that moves data from one excel sheet to another with the following statement:

Worksheets("Sheet1").Range("A1:A10").Value = Worksheets("Sheet3").Range("B1:B10").Value

Everytime that I get to this statement & try to execute it I get the following error message:

RUN-TIME ERROR '9' Subscript out of range!?

What subscript is actually being referenced in the above statement??

The following is the actual data that is contained in the worksheet("Sheet1"):

OneTouch (R) Diabetes Management Software v2.3.3 P1/V2.3.3 10.29.10
1033 , 1033
mg/dL
Date Format : M.D.Y
Time Format : 24:00
Total Number of Readings in Data File: 21499
Patient Name: Johnson, Thomas Roy
Sample # Date Time Med Strength
21499 07/17/13 7:59 PM 2.5 CFT0437DV
21498 07/17/13 7:59 PM 1 CFT0437DV


All I want to do is move this data from one sheet to another *** the statement suggest but there seems to be an issue with what I have provided in the VBA statement. If someone can point out the error of my ways, I would greatly appreciate it.

Thanks in advance . . .
TomJ.

Hi,

this error pops up when one of the worksheets does not exist in the activated workbook. Please make sure that "Sheet1" and "Sheet3" are the worksheet names you also see in the tabs.