Const Array

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sören_Marodören - 25 Jan 2007 08:44 GMT

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

Reply to this Message

Bob Phillips - 25 Jan 2007 09:31 GMT

I don't think that you can do it in the declaration, you need to dim it and
then assign it.

But just dim it as a variant variable, don't bound it.

Dim InterestRate

InterestRate = Activesheet.Evaluate("{0.07,0.071,0.06,0.063}")

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Hi,
>
[quoted text clipped - 10 lines]
> Best regards,
> /Sören

Reply to this Message

Sören_Marodören - 25 Jan 2007 12:45 GMT

I have found a better soulution:

Dim InterestRate As Variant 'Not needed to do
InterestRate = Array(0.07, 0.071, 0.06, 0.063, 0.055, 0.059)

The Array function is new for me, but I found it in the book 'Excel 2003
Power Programming with VBA', by John Walkenbach, page 295.

BR,
/Sören

> I don't think that you can do it in the declaration, you need to dim it and
> then assign it.
[quoted text clipped - 19 lines]
> > Best regards,
> > /Sören

Reply to this Message

Bob Phillips - 25 Jan 2007 13:09 GMT

Better? Different yes, but not necessarily better.

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

>I have found a better soulution:
>
[quoted text clipped - 32 lines]
>> > Best regards,
>> > /Sören

Reply to this Message