For Loop: Workbooks in Application

Sub ForLoop_WoorkbooksInApplication()
    Dim i as Integer
    For i = 1 To Application.Workbooks.Count
        MsgBox Application.Workbooks(i).Name 'Index is 1 based
    Next i
End Sub

For Loop: Workbooks in Application

What is VBA?

Performance Tunning: ActivateCell vs Cell Referance

For Each Loop: Cells in Range

For Each Loop: Workbooks in Application

Copy Cells From One Range to Another Without Using Selections

Get the Row and Column Number of the Last Cell Containing Data

Copy a Folder and all of its Contents

Compact and Repair Access Databases by Searching Directories and Sub-Folders

Copy a Folder and all of its Contents

Introduction to VBA in Microsoft Word

For Loop: Workbooks in Application

For Each Loop: Workbooks in Application

Adsense

For Loop: Workbooks in Application

Share this:

Adsense