Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting CONST referencing a cell Value | Excel Programming | |||
public const availability? | Excel Programming | |||
Not recognizing a Const | Excel Programming | |||
Public Const on a Drive | Excel Programming | |||
crash changing const to public const | Excel Programming |