Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT function for two arrays. Array 1 contains text | Excel Worksheet Functions | |||
SUMPRODUCT where arrays have different dimensions | Excel Discussion (Misc queries) | |||
Array function, two dimensions?? | Excel Programming | |||
Checking existence of array dimensions | Excel Programming | |||
Checking Number of Dimensions In Array | Excel Programming |