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).
- You tried to declare an array using a variable to specify the number of elements.
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).