ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Declaring array constants at module level (https://www.excelbanter.com/excel-programming/321502-declaring-array-constants-module-level.html)

Microsoft Forum

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.



Tom Ogilvy

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.





Microsoft Forum

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.








All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com