Hi ,

What is the best method to select a workbook to run macro? I have tried 2 different codes (Below), but both of them sometime gives error: 'Subscription out of Range'. Also this seems an intermittent problem as sometime it works fine.

Code:
Workbooks("Mydata").Activate

Code:
Windows("Mydata").Activate
Thanks
Rajesh