ExcelBanter - Switch between workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Switch between workbooks (https://www.excelbanter.com/excel-programming/287138-switch-between-workbooks.html)

Newbie

Switch between workbooks

What's the equivalent VBA expression of 'Ctrl + Tab' in Excel

Thanks

btadams[_5_]

Switch between workbooks

To switch to a specific workbook use

Workbooks("MyWorkBook.xls").Activate

To cycle thru all open workbooks use:

WBCount = Workbooks.Count
For i = 1 to WBCount
Workbooks(i).Activate
'Do something to workbook
next

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 02:37 AM.