Thread: Const Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sören_Marodören Sören_Marodören is offline
external usenet poster
 
Posts: 18
Default Const Array

Hi,

I want to declare some arrays of constants.
One array has 5 elements as String, and some other arrays can have up to 100
elements as Single.
Can I do it in a single statement like: "Const InterestRate as Single =
0.07" but with allot more data?
Or do I have to first define a variable "Dim InterestRate (1 To 100) as
Single" and then assigning it by "InterestRate =
Evaluate("{0.07,0.071,0.06,0.063}") " (I'm not sure if this works...)


Best regards,
/Sören