For Loop: Documents in Application

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

For Loop: Documents 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

Compact and Repair an Access Database

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

Merging Multiple Workbooks Together by Searching Directories and Sub-Folders

For Loop: Presentations In Application

Adsense

For Loop: Documents in Application

Share this:

Adsense