Hello everyone,

I have a simple question that I can't deal with by myself.
I couldn't find if it was solved earlier (>500 search results - it's easier to read all the forum), so don't blame me if it really was.

I want to make a Public Const of an array of a fixed size. Something like
Public Const A(10) = ... and then declare somehow each of 10 entries in A().

Reason: I need a list of strings, avaliable from anywhere in the project. I have many worksheets; of them are special ones ("Final Report", "input data"), others are looped through for varoius actions. I need constants with their names. Now I have only two "special" sheets, but I want to make my code "easy-to-scale", so an array avaliable from anywhere in the project would be terrific...

Thank you!! ^_^