For Each control variable on arrays must be Variant
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).