Hi,
I am using Excel 2003 on Win XP Pro.
In my code I defined a workbook object named Newbook and then used following code to assign it a workbook
Set Newbook = Workbooks.Add
When I try to copy from another open workbook to this Newbook, I get error that Subscript is out of range.
Here is the code I used:
Workbooks("EVDO Daily_Trending_PHIL1").Worksheets("Fwd_MB").Range("A:IV").Copy Workbooks("Newbook").Worksheets("Fwd_MB").Range("A:IV")
Any help is appreciated. Thanks,
I am using Excel 2003 on Win XP Pro.
In my code I defined a workbook object named Newbook and then used following code to assign it a workbook
Set Newbook = Workbooks.Add
When I try to copy from another open workbook to this Newbook, I get error that Subscript is out of range.
Here is the code I used:
Workbooks("EVDO Daily_Trending_PHIL1").Worksheets("Fwd_MB").Range("A:IV").Copy Workbooks("Newbook").Worksheets("Fwd_MB").Range("A:IV")
Any help is appreciated. Thanks,