View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Declaring array constants at module level

To the best of my knowledge, you can not have a constant array.

--
Regards,
Tom Ogilvy

"Microsoft Forum" wrote in message
...
Hi all,

I have a group of constants which are stored in a single array. This array
is to be accessed by all subroutines and functions within the same module.
Is it possible to declare an array and assign values within it in the

module
level? The following seems doesn't work:

Const PublicArray = Array(1,2,3)

Please advise.

Frederick Chow
Hong Kong.