Array function, two dimensions?? and worksheet arrays
Hi
example A
Dim A As Variant
A = Array(10,20,30)
B = A(2)
the above is straight from Excel help on array functions.
If have used two dimension arrays like this befo
example B
dim stuff(20,20) as integer
where stuff( var1, var2) gets me to where I want.
Q1) Can you 'do' exampleA in two dimensions?
Q2) the Excel text for example A says that 10,20,30 arglist are values.
Can what's inside the parenthesis be variable names containing values?
Q3) New topic:
I can't seem to find an example of how to specify an array of cells
for worksheet formulas (NOT a vba array)
will you provide a brief example?
Thanks much,
--
Neal Z
|