View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Microsoft Forum Microsoft Forum is offline
external usenet poster
 
Posts: 17
Default Declaring array constants at module level

Thanks a lot.

Frederick Chow
"Tom Ogilvy" wrote in message
...
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.