How to select a workbook?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
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
 
Back
Top