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
|