Invalid data type for constant

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

Not all types of data can be assigned to constants. This error has the following cause and solution:

• You tried to declare the type of a constant to be a user-defined type, an object, or an array.

  Remove the declaration or redeclare as a variable.

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