How to select a workbook?

[Eric]

I open two workbooks at the same time, and would like to setup a macro to
select workbook "mybook.xls", and bring it into the upfront.
Does anyone have any suggestions on how to do it in execl?
Thanks in advance for any suggestions
Eric

 

[ozgrid.com]

Workbooks("mybook.xls").Activate

 

[FSt1]

hi
Workbooks("mybook.xls").Activate
after that you may need to do more selecting.
sheets("sheet1").activate
range("A1").select
or
Cells(1,1).select

regards
FSt1

 

[ozgrid.com]

Or use GoTo;

Application.GoTo Workbooks("mybook.xls").Sheets(1).Range("A1")