Constant Array?

[Pherion]

Is it possible to use a contstant array in Excel VBA? I have tried several differnt ways to declare it, but the VBA editor keeps yelling at me. The following did not work:

Please Login or Register  to view this content.

[Andy Pope]

No is the short answer.

Possible work around
http://www.excelforum.com/excel-prog...as-arrays.html

[Pherion]

Perfect, thanks!