Qualifier must be collection

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

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