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

For Each Loop: Cells in Range

Parsing a File String Into Path, File Name, and Extension

For Loop: Presentations In Application

For Loop: Worksheets in Workbook

Adsense

For Loop: Workbooks in Application

Share this:

Adsense