Posted to microsoft.public.excel.programming
|
|
VBA Array Population with a Single Line of Code
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!
.
|