Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel vba array basic operations
Hello,
I just want to create my own function in vba that involve basic array operations. I've already implemented them in an excel spreadsheet and I thought it would be rather straightforward to create the functions in vba. For instance, I wanted to test a function that perfoms a difference between two arrays (3;5) and (1;2). In a worksheet I just select the next two cells, enter the formula and CTRL-Shift-Enter and voila (2;3). But when I select the appropiate range and call the following function, it just doesn't work. Function diffArray(vector1, vector2) As Variant diffArray = vector1 - vector2 End Function Any hint? Gabriel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel vba array basic operations
You have to loop and do the comparison element for element, then store the
results in a third array. There are no built in Array operations in VBA. -- Regards, Tom Ogilvy Gabriel wrote in message om... Hello, I just want to create my own function in vba that involve basic array operations. I've already implemented them in an excel spreadsheet and I thought it would be rather straightforward to create the functions in vba. For instance, I wanted to test a function that perfoms a difference between two arrays (3;5) and (1;2). In a worksheet I just select the next two cells, enter the formula and CTRL-Shift-Enter and voila (2;3). But when I select the appropiate range and call the following function, it just doesn't work. Function diffArray(vector1, vector2) As Variant diffArray = vector1 - vector2 End Function Any hint? Gabriel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel vba array basic operations
You might want to review some of the functions in the freely
downloadable file at http://home.pacbell.net/beban. The following, for example, will produce the result you are describing: =ArrayAdd(vector1,vector2,false) The loops are included in the function. Alan Beban Gabriel wrote: Hello, I just want to create my own function in vba that involve basic array operations. I've already implemented them in an excel spreadsheet and I thought it would be rather straightforward to create the functions in vba. For instance, I wanted to test a function that perfoms a difference between two arrays (3;5) and (1;2). In a worksheet I just select the next two cells, enter the formula and CTRL-Shift-Enter and voila (2;3). But when I select the appropiate range and call the following function, it just doesn't work. Function diffArray(vector1, vector2) As Variant diffArray = vector1 - vector2 End Function Any hint? Gabriel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simulation in operations research using Excel | Excel Worksheet Functions | |||
Excel Iterations? Conditional Operations? | Excel Discussion (Misc queries) | |||
Excel Iterations? Conditional Operations? | Excel Worksheet Functions | |||
OWC operations in Excel | Excel Discussion (Misc queries) | |||
Basic Array Question | Excel Discussion (Misc queries) |