Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Functions
To those, if any, who use the array functions in the freely downloadable
file at http://home.pacbell.net/beban: I refreshed the file today with changes I have been making during the past month or so. Most of the changes were tidying things up, including generalizing many of the functions so that they would better handle non-variant arrays. I did add one new function, Assign, which facilitates the "direct" assignment of a range to a non-Variant() array. I.e., in Excel the following is the normal way to load a Variant() array from a worksheet range Dim arr() As Variant arr = Range("a1:j10") but it can't be used for non-Variant() arrays. The following now can (if the array functions are available to your workbook): Dim arr() As Integer Assign Range("a1:j10"), arr Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array functions | Excel Worksheet Functions | |||
array functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Array Functions | Excel Discussion (Misc queries) | |||
Array functions | Excel Discussion (Misc queries) |