Norman Jones wrote:
Hi Alan,


Well, with respect to being to the point, the responders are suggesting
code to load a Variant() type array, while the OP is looking to load a
Double() type array, and never the twain shall meet.


The OP's initial post said:

'========================
Is there some elegant way to assign values to array, for ex:
dim A(3) as integer {1,2,4}

instead of
dim A(3) as integer

A(1)=1
A(2)=2
A(3)=4

'========================

My response was directed to that question.

Understood. But the OP's post at 9:28am on 11/24 stated

"I tried it already... it says "cannot assign to array" when it comes to
2nd line."

made it clear (at least to me), when coupled with his original posting
including

Dim A(3) as integer

that the problem was he was continuing to try to load a non-Variant()
type array.

Cheers,
Alan Beban