Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Declaring array constants at module level
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
declaring constants from the sheet? | Excel Programming | |||
Declaring one bidimensinal Array | Excel Programming | |||
referencing at module level | Excel Programming | |||
module-level variable lifetime | Excel Programming |