Table of contents
TOC
Collapse the table of content
Expand the table of content

For Each control variable must be Variant or Object

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

A control variable is the element part of the For Each...Next statement syntax. This error has the following causes and solutions:

  • A collection has a control variable that isn't a Variant or Object type.

    Make sure the element part of the For Each...Next is a Variant or Object.

  • An array has a control variable that isn't a Variant.

    Make sure the element part of the For Each...Next is a Variant.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

© 2018 Microsoft