What's the equivalent VBA expression of 'Ctrl + Tab' in Excel Thanks
B btadams Jan 7, 2004 #2 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
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
