Thanks, Alan.

These VBA functions should add a lot of firepower to the
array manipulation I've been working on (reservoir
simulation).

- James

-----Original Message-----
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!

.