For Each Statement

Syntax:

For Each var In items

statements

Next [var]

Group: Flow Control

Description:
Execute statements for each item in items.

Parameter Description

items This is the collection of items to be done.

See Also: Do, For, Exit For, While.

Example:

Sub Main
  Dim Document As Object
  For Each Document In App.Documents
  Debug.Print Document.Title
  Next Document
End
Sub