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

For Each control variable on arrays must be Variant

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 cause and solution:

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

    Make sure the group part of the For Each...Next is a Variant type variable.

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

© 2018 Microsoft