Hi,

dimensioning a scalar variable and declaring its data
type in VBA is no problem:

Dim a As Double

What if I want the variable to hold an array with multiple
components, all with Double precision? This doesn't seem
to work:

Dim a As Double
a = Array()
ReDim a(2)

Thanks a lot for suggestions!
Tom