Constant expression required

A constant must be initialized. This error has the following causes and solutions:

  • You tried to initialize a constant with a variable, an instance of a user-defined type, an object, or the return value of a function call.

    Initialize constants with literals, previously declared constants, or literals and constants joined by operators (except the Is logical operator).

  • array

    To declare a dynamic array within a procedure, declare the array with ReDim and specify the number of elements with a variable.

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