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
EndSub