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

  • Var This is the iteration variable.

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