Workbook activate event in VBA

[anand_babu123]

HI All,

I am new to VBA. I have 2 workbooks named a.xls and b.xls. I am trying to activate a cell in the workbook b.xls by writing code in a.xls.

I used the below code in workbook a.xls and got error msg as "Activate method of range class failed".

code:

Workbooks("b.xls").Sheets("Data").Range("a10").Activate

Kindly guide me.

 

[VoG]

Try

Application.Goto Workbooks("b.xls").Sheets("Data").Range("a10")

 

[anand_babu123]

Hi VoG,

Thanks a lot, That works fine.
</SPAN></SPAN>