Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch between workbooks
What's the equivalent VBA expression of 'Ctrl + Tab' in Excel
Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switch x and y axes | Charts and Charting in Excel | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
Using alt-tab to switch between Excel workbooks under the same session | Excel Discussion (Misc queries) | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
switch statement | Excel Discussion (Misc queries) |