VBA using an array
 

I have an array Array(100)

and I want to set Array() = 10 for 1-100

Is there another way to set = 10

rather then using

For i = 1 to 100
Array(i) = 10
Next I

Thanks for your help

VBA using an array
 

Not really. But why worry? Even if that loop went to 100000 it'd be a
fraction of a second!
"Jeff" wrote in message
...
I have an array Array(100)

and I want to set Array() = 10 for 1-100

Is there another way to set = 10

rather then using

For i = 1 to 100
Array(i) = 10
Next I

Thanks for your help

VBA using an array
 

There are other ways, but probably all less efficient that that loop.

The loop is pretty fast.

In article ,
"Jeff" wrote:

I have an array Array(100)

and I want to set Array() = 10 for 1-100

Is there another way to set = 10

rather then using

For i = 1 to 100
Array(i) = 10
Next I

Thanks for your help