Can you create a Constant array

[deadseasquirrels]

Is it possible to establish a constant array that holds, say email addresses, to be used later on for automatic mailing functions? I could always just embed the array within the function, but i figured having the array sitting outside the function would be easier to manipulate if I end up adding and deleting names on a regular basis. Also I don't want to put the email addresses in another sheet, I'm trying to have it as self-contained as possible. Thanks.

 

[OdinsDream]

I have an array that I declare like this:

Public Entries(1 To 15, 7 To 23) As String

and then I fill it with a subroutine before my others run, called FillEntriesArray() which does something like:

Entries(1, 7) = "(X)"
Entries(2, 15) = "X"
.... and so on.

You can also use arrays directly with the Array function, like so:

For Each Entry in Array(1,2,3,4,5)