The getarray function from the first post in this series, plus functions to transpose, count the number of dimensions, and return other information about arrays, ranges or values:
http://www.interactiveds.com.au/software/getarray.zip
Chip Pearson’s Functions for VBA Arrays (also have a look at his index page, there is a huge amount of information and downloads on arrays)http://http://www.cpearson.com/Excel/VBAArrays.htm
Alan Beban’s array functions
http://http://home.pacbell.net/beban/
Colo’s Junk Room VBA tips, starting off with arrays
puremis.net/excel/tips.shtml
Microsoft Developer Center on understanding arrays
msdn2.microsoft.com/en-us/library/aa164778(office.10).aspx
Don’t forget “Using Array Formulas in Excel” by Bob Umlas:
http://www.emailoffice.com/excel/arrays-bobumlas.html
LikeLike
Thanks Jon. Excellent Link.
LikeLike
Pingback: Daily Download 30: Data Transfer, to and from VBA | Newton Excel Bach, not (just) an Excel Blog