A
Alan Beban
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
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