For Each control variable must be Variant or Object

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).