As for your first question

Option Base 1
___________________
Sub junk()
Dim a()
a=Array(2,3,5,7)
End Sub

As for your second, with the functions in the freelydownloadable file at
http://home.pacbell.net/beban available to your workbook

Option Base 1
___________________
Sub junk2()
Dim beta, arr
beta = Range("a1:p13")
arr = Array(103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114)
ReplaceSubArray beta, arr, 7, 3
End Sub

Simply, replace that portion of beta beginning at row index 7, column
index 3 with the elements of arr.

Alan Beban

James B wrote:
I'm trying to figure out how to populate an array variable
in VBA without using something similar to the code below:

ReDim a(1 To 4)
a(1) = 2
a(2) = 3
a(3) = 5
a(4) = 7

Can this be done with a single line of code? Also, can I
populate a single section of a multidimensional array with
something like the following?

beta(7,3 to 14)= ..... the values for those points in the
array

Any help is certainly appreciated. I've been doing this
the long way for years, and it is driving me crazy!