Array Functions
Alan Beban has a downloadable Excel file chock full of array functions. He’s written these functions in VBA to allow you to maniupulate arrays.
From Alan’s site:
The file “Array Functions” contains 27 Function Procedures and 2 Sub Procedures for manipulating arrays (and worksheet ranges).
The best part is that the code is unprotected so you can see (and learn) what’s going on. Alan probably knows more about working with arrays than anyone. He’d have to just to write these functions. Check them out if you work with arrays.
Do you have Alan Beban’s email address? I attempted to download his array functions workbook after reading about it on your site. It seems to have overwritten all the macros in my Personal Workbook!!