Qualifier must be collection

The use of an exclamation point between two identifiers is specific to collections. This error has the following cause and solution:

• You used a name on the left side of the exclamation point (!) that isn't the name of a collection. If the name is supposed to represent a collection, check to make sure the name is spelled correctly. Note that the exclamation point is also the type-declaration character for the Single data type. If the name in question isn't supposed to be a collection, perhaps the ! type-declaration character appended to a variable name has been concatenated with another name.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.