Is it possible to use a contstant array in Excel VBA? I have tried several differnt ways to declare it, but the VBA editor keeps yelling at me. The following did not work:
![]()
Public Const VarName(1 to 5) as string = (values) Public Const VarName(5) as string = (values) Public Const VarName[5] as string = (values)
Bookmarks